Reconciling Payments in QuickBooks Desktop

Derek Torres
Derek Torres
  • Updated

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

  1. Retrieve the current deposit report from the Payment Portal.
  2. In QuickBooks Desktop, click Customers, then click Receive Payments.
  3. The Customer Payment input screen appears. Enter the following information from the first row of the deposit report CSV file:
    • Received From - The customer name in the ‘customer_company’ column.
    • Payment Amount: The amount in the ‘total’ column.
    • Select the appropriate form of payment - 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.Reconcile-QBD 1.png
  4. The list of open invoices for this customer will appear (if any). Enter the appropriate payment amount in the Payment column for each invoice.
  5. Click Save and New at the bottom of the Customer Payment screen.
  6. Repeat steps 3-5 for each subsequent line on the deposit report.
  7. Once all payments have been entered, click Banking, then Make Deposits.
  8. On the Payments to Deposit screen, select all the payments that you want to deposit.
  9. Then click the OK button.
  10. On the Make Payments screen, select the desired bank account to which the deposit should be applied.
  11. Add a line to record the merchant fees associated with your credit card batch:
    • Account - Merchant Fees (or a similar expense account of your choosing.)
    • Amount - The total of all fees from your batch, represented as a negative number.
  12. Click the Save and Close button.

Was this article helpful?




Please sign in to leave a comment.