Quickbooks Desktop Reconciliation
Your step-by-step guide for accurate reconciliation with Quickbooks Desktop.
Last updated
Was this helpful?
Your step-by-step guide for accurate reconciliation with Quickbooks Desktop.
Last updated
Was this helpful?
This step-by-step guide walks you through reconciling payments in QuickBooks Desktop. It covers the accounts required to select for payments and deposits after connecting Quickbooks Desktop within the Alternative Payments dashboard, and complete bank reconciliation for deposits. Following these steps will help you accurately match bank transactions to invoices and keep your financial records well-organized.
In the Alternative Payments dashboard, you’ll assign three types of accounts:
Payments Account: Select the "Undeposited Funds" account. This temporarily holds payments until they are reconciled with your bank account.
Deposits Account: Choose the bank account where Alternative Payments will deposit your payouts.
Fees Account: Assign an account to track fees if you absorb them on behalf of your customers. If no account is selected, we’ll create one for you, labeled Alternative Payment Fees, to ensure proper recording of all fees
Step 1: Recording Payments
When a custom makes a payment, we will immediately send the payment and record it to the Undeposited Funds account.
In the example below, you can see that $9,324 that has been recorded in the Undeposited Funds account:
When reviewing the payments, you'll notice there are no transaction IDs yet, as the payout from Alternative Payments has not been issued that encompass two invoice payments:
$8890
$444
Step 2: Recording the Deposit
When Alternative Payments issues the payout to your bank account, the funds will be automatically transferred from Undeposited Funds to your bank account.
In the example below, you can see the $9,324 dollars was moved from Undeposited Funds into the NuBank account.
Step 3: Performing the Bank Reconciliation
Now that the funds have been deposited and recorded in Quickbooks Desktop, the payment IDs are now visible within the bank account record:
By following these steps, you can streamline your reconciliation process and maintain accurate financial records. If you need further assistance, don’t hesitate to reach out to our Customer Experience team at customersuccess@alternativepayments.io or by sending us a message via the Live Chat within your partner dashboard.
