QuickBooks FAQ

Why do I have to match deposits?

You must match deposits from your bank with QuickBooks orders. Otherwise, the income is recorded twice. Your merchant account fees will be missing, so you are taxed on an expense. 

How do payment processors work?

When you are paid online, a payment processor collects the funds and holds them in a staging area to clear. They typically deposit on a two-day schedule. All of Monday's sales are direct-deposited into your bank account by Wednesday. Most processors take a commission of about 1-3% per transaction before they deposit. You must add these fees as an expense, so you pay no taxes on them. To add fees, you must match them to a group of orders and deposits from your bank.

How do I connect my bank account to QuickBooks?

QuickBooks has a copy of your bank account's withdrawals and deposits. Bookkeepers and Accountants match the bank account and the QuickBooks register. You can view this account in QuickBooks by clicking the gear box and selecting chart of accounts. For example, below is a screenshot of a bank register:


Without adding your bank feed, you must add the withdrawals and deposits one-by-one. To add the bank account feed, here are the steps:

  1. Log into QuickBooks.
  2. On the left, click banking.
  3. Follow the on-screen instructions to add a bank account. You should see a button saying nothing has been added if you are a new user. Otherwise, click add account.

QuickBooks will populate a list of deposits and withdrawals from your bank account. You will be asked to accept these transactions. Once you accept, they are moved to your bank account. Here is a sample deposit to match:

What is this deposit that QuickBooks matched?

In this image, you see match deposit. We have already created a deposit manually before connecting the bank account, so we can show you the process. The amount and date in your register are the same as your bank. If you click deposit, you will see this screen:

Without the Connex for QuickBooks match deposit tool, you must locate the orders matching the $3,114.98 deposit. Then, add the fees at the bottom. Connex records the gross sales without merchant processor fees. You can pull a settlement report from your payment processor to locate the fees and matching orders. 

Why do I have to match deposits?

If you click accept without matching, QuickBooks will add the $3,114.98 to your bank register. QuickBooks also has the sales, so your income would be reported twice. In QuickBooks, go to reports and click profit and loss. You will see an extra $3,114.98 in your sales account. Without matching, no merchant fees are recorded and will be taxed on this expense.

Can Connex match deposits?

Connex can match deposits, depending on your payment processor. Connex can find matching orders in QuickBooks that match the deposit, then add fees. In the example, Connex could have located the orders matching the $3,114.98 deposit and added the $85.02 in fees. Instead, the deposit was done manually.




Can't find what you're looking for? Let us help you right now!