Reconciling Payments in QuickBooks Online

This article will walk you through Reconciling Payments for the Payment Portal in QuickBooks Online

1. Retrieve the current deposit report from the Payment Portal.
2. In Quickbooks Online, click the + New button.
3. Under the Customers section, click Receive Payment.
   
4. On the Receive Payment screen, enter the following information from the first row of the deposit report CSV file:
   • Customer - The customer name in the ‘customer_company’ column.
   • Payment Method
     • If the value in the ‘method’ column is ‘bank’, then select ‘e-Check’.
     • If the value in the ‘method’ column is ‘card’, then select the appropriate credit card type, based on the value in the ‘card_type’ column.
   • Deposit To - Select Undeposited Funds to create a single bank deposit batch for all your payments (recommended), or select the bank account to which you wish to deposit the payment.
   • Amount Received: The amount in the ‘total’ column.
5. The Outstanding Transactions list for this customer should appear. Enter the appropriate payment amount in each invoice's ‘Payment’ column.
6. Click ‘Save and New’ at the bottom of the Receive Payment screen
7. Repeat steps 4-6 for each subsequent line on the deposit report.

*Optional Step: If you Selected  'Undeposited Funds

If you selected ‘Undeposited Funds’:

1. In Quickbooks Online, click the + New button.
2. Under the Other section, click Bank Deposit.
   
3. Select the bank account to which you wish to deposit the batch of payments, then select each payment that you wish to include in the batch.
   
4. Click Save and Close at the bottom of the page.