You can now reconcile Braintree payments in QuickBooks Online in no time using PayTraQer. You just have to spend a few clicks to do so. Observe the steps carefully for a sweat-free reconciliation.
Steps to Reconcile Braintree Payments in QuickBooks Online using PayTraQer
Prepare QuickBooks Online for Reconciliation
Step 1: Create a bank account named ‘Braintree Bank Account’ (or any name) in QuickBooks Online. This account will be used only to record your Braintree transactions.
Do not use the checking/current account to directly record your Braintree transactions to avoid issues at the time of reconciliation.
Step 2: Set up the bank feed in QuickBooks Online or upload the bank statement in QuickBooks Online. You can see the downloaded transactions in the bank review section.
Set up PayTraQer
Step 1: Install PayTraQer and connect it with QuickBooks Online. (See how)
Step 2: Connect your Braintree account with PayTraQer. (See how)
Step 3: Configure the sync setting for Sales, Products & Services, Tax and Payouts. (See how)
Step 4: Sync your Braintree transactions into QuickBooks Online. (See how)
While configuring the settings, you need to select the same bank account (Braintree Bank Account or created account) for Sales, Products & Services, Tax and Payouts in PayTraQer.
Configure Braintree Sales settings with your Braintree Bank Account.
Configure Braintree Payout settings with your transfer sales account.
QuickBooks Online Bank Review
Step 1: Navigate to the Banking Section in QuickBooks Online, you could see that the TRANSFER transactions of "Braintree Bank Account" is matched against your deposits. These TRANSFER transactions won't be created if you have not enabled Payout processing in PayTraQer.
Step 2: Click the "Match" link to accept the transactions.
You can also create TRANSFER transactions directly in the Bank Review screen if it is not available.
QuickBooks Online Reconciliation
Step 1: Click ‘Reconcile’ from the Accounting tab, listed on the left of the QuickBooks Online screen.
Step 2: Specify your Ending Balance and Ending Date.
Step 3: Click ‘Start Reconciling’ to start the process.
QuickBooks Online automatically matches the transfers and deposits and marks the transactions as reconciled.
Now your QuickBooks Online Braintree sales are matched with your checking account.