Reconciling Payments in QuickBooks Online

Derek Torres
Derek Torres
  • Updated

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.
    Receive Payments 1.png
  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.
    Reconcile QBO 2.png
  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.
    Reconcile QBO 3.png
  4. Click Save and Close at the bottom of the page.

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.