Reconciling Payments in Sage Intacct

This article will walk you through Reconciling Payments for the Payment Portal in Sage Intacct.

1. Retrieve the current deposit report from the Payment Portal.
2. In Sage Intacct select Applications.
3. Click Accounts Receivable → + Invoices → Receive a payment.
   
4. The Invoices for Payment screen appears. Enter the following information from the first row of the deposit report CSV file:
   • Payment Method
     • If the value in the ‘method’ column is ‘bank’, then select ‘Check’.
     • If the value in the ‘method’ column is ‘card’, then select ‘Credit Card’.
   • Account Type / Account - Select the appropriate account type and account.
   • Customer - The customer name in the ‘customer_company’ column.
     
5. In the Payment Information section, enter the following information:
   • Credit Card (if ‘Credit Card” was selected as the payment type) - Select the appropriate credit card type, based on the value in the ‘card_type’ column.
   • Payment Amount - The amount in the ‘total’ column.
     
6. In the Available Invoices and Dedit Memos section, enter the appropriate payment amount in the Amount Received column for each invoice, then click the Save button.
   
7. Repeat steps 4-6 for each subsequent line on the deposit report.
8. Once all payments have been entered, go to Applications → Accounts Receivable → Payments → Deposits.
   
   
9. On the Deposits list, click the Add button.
   
10. On the Deposit screen, select the bank account into which you wish to deposit.
11. Then click the Continue button.
    
12. In the Deposit Details section that appears, check to select all the payments that you wish to deposit.
    
13. Click the Save button in the upper right-hand corner of the screen.