Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 13, 2020
Question

I downloaded my bank transactions and use the banking tab and have to fill in all the names and categories, but most of them are there in the expenses tab. I don't get it

  • March 13, 2020
  • 1 reply
  • 8 views
No text available

1 reply

Level 4
March 13, 2020

Hi gshuck1960.

 

To help you resolve this expense issue, you’ll need to follow the steps provided below to exclude them from your downloaded bank transactions. This will streamline everything for you moving forward.

 

Follow these steps to get started:

 

Exclude transactions

 

1. Select Banking 
2. On the Banking page, select the For Review tab
3. Select the check boxes of the transactions to exclude.
4. From the Batch actions drop-down, choose Exclude Selected.

 

Excluded transactions are listed on the Excluded tab for reference or review, but are not tracked or reported as part of your business finances and don't appear in any associated account registers or reports.

 

Include previously-excluded transactions

 

If you have accidentally excluded a transaction, you can easily include it again:

 

1. Select Banking.
2. On the Banking page, select the Excluded tab.
3. Select the check boxes of the transactions to include again.
4. From the Batch actions drop-down, choose Undo.

 

The transactions are returned to the For Review tab where you can categorize, add or match the transactions again.

 

Excluded transactions and reconciliations

 

Excluding duplicate transactions does not affect reconciliations. If you exclude a download transaction because it's a duplicate, when you reconcile the account, your balances will match.

 

If you exclude transactions for personal expenses, your bank register wont reconcile because the bank balance and the QuickBooks balance won't match.

 

This is not an issue if you don't reconcile your bank statements with QuickBooks Online, but if you do (or if your accountant instructs you to do so), you can track your personal expenses by adding yourself as a vendor and assigning the transactions to an owner's equity account. (often called an owners's draw). 

 

I was able to find this information as well as many more helpful articles here

 

This should help you properly categorize everything. If you need help with anything else, I'm only a click away. 

March 13, 2020

I must be doing it wrong, to reconcile and accounting purposes do I need to do all the work on the banking tab.