How to Reconcile Jobber Payments with QuickBooks
When Jobber Payments sync over to Quickbooks, they sync over the full amount of the payment to the client as "Unapplied funds" or "Undeposited funds" and need to be reconciled to your correct Chart of Accounts within QuickBooks.
The amount deposited to the your bank account though is the total minus the processing fees. This is because Jobber Payments takes off the fee from each transaction before depositing it.
To reconcile deposits and payments, to account for the Jobber Payments fees, you would do this within Quickbooks. This is very similar to how you would handle processing fees for other credit card processors, such as Paypal.
When your bank account also syncs into QuickBooks, you’ll have two "unapplied" payments for the same Invoice. The payment note comes from Jobber and the deposit note comes from your bank account. The deposit note is the Jobber Payments transfer less the Credit Card fees. You will need to enter an adjustment for your Credit Card fees in the QuickBooks deposit section after matching up the deposit with the invoices from Jobber.
Jobber Payments Reports
In Jobber you can see the breakdown of transfers that have been sent to your bank account by clicking the Management tab and then finding “Transfers” in the menu under Jobber Payments. This will open your Payment Transfers report. Clicking on the transfer will tell you the transactions it includes, the transaction amounts, and your net amount for that transfer.
On the Jobber Payments Transaction List (Management > Transactions under Jobber Payments) you can find the exact amount of fees that were charged per transaction. You might need to click the "Columns" button to have it show the Fees column. Filter this report for the specific date range of all transactions that appear in the transfer to find the fees for that transfer.
We found this helpful article that is a good walk through for how to handle this in Quickbooks: https://5minutebookkeeping.com/how-to-enter-paypal-fees-and-merchant-fees-in-qbo/
We recommend consulting a certified accountant if you have any accounting questions about this.
The Jobber Glossary
Confused by language we use in Jobber? Definitions right this way.Get Reading!
Sign up for a Webinar
Tutorials for both those new to Jobber and long-time power users.Sign Me Up!
We walk you through our biggest features and point out the essentials.Let’s Watch!