This article will walk you through Reconciling Payments for the Payment Portal in QuickBooks Online
- Retrieve the current deposit report from the Payment Portal.
- In Quickbooks Online, click the + New button.
- Under the Customers section, click Receive Payment.
- 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.
- The Outstanding Transactions list for this customer should appear. Enter the appropriate payment amount in each invoice's ‘Payment’ column.
- Click ‘Save and New’ at the bottom of the Receive Payment screen
- Repeat steps 4-6 for each subsequent line on the deposit report.
*Optional Step: If you Selected 'Undeposited Funds
If you selected ‘Undeposited Funds’:
- In Quickbooks Online, click the + New button.
- Under the Other section, click Bank Deposit.
- 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.
- Click Save and Close at the bottom of the page.
Comments
0 comments
Please sign in to leave a comment.