Manually uploading credit card statements

Construction_C · ‎July 30, 2021

My main bank accounts are connected via an automatic feed in QBO so I just go through these in the dashboard tab and match them to the bills that are entered. I have recently got a capital on tap credit card that I have to manually upload the transactions for so that they appear in the dashboard. I want to be able to match the transactions from the credit card statement to the bills I've entered the same as I do for the other bank accounts. I'm finding though that the credit card statement when I manually upload it is duplicating and the entries are all going in as uncategorized expenses. If the bills are entered, this then duplicates the entries in my expense accounts - one for the bill, one for the credit card transac They don't do this on the automatic feed so why do they do this when I manually upload them? I'm not sure what I'm doing wrong or how to fix it?

John C · ‎August 02, 2021

Hi Construction_C Are there any banking rules that have been created that have the 'Auto-add' selected(you can view this in the menu on the left hand side if you select Bookkeeping and then select Rules and then look at the auto add section)? If you do not want that to happen and you can see on the rule it is selected go to edit on that rule and then toggle off the auto add and then save.

In regards to getting rid of a duplicate the best thing to do is exclude them as below in the banking section.

Go to the For review tab.
Select the checkbox for each transaction you want to exclude.
Select Exclude. Excluded transactions then move to the Excluded tab. They won’t be added to QuickBooks or downloaded again.

Any questions feel free to add them to this thread

View solution in original post

AlexV · ‎July 30, 2021

Hi Construction_C! Thanks for reaching out to us.

You can match the credit card transactions to the entries entered in QuickBooks Online just like bank accounts. Allow me to help you.

After you uploaded the credit card transactions, you can match them as you normally do. If they were categorised automatically, it's possible that there's a banking rule, or the system recognises that there are similar entries you categorised before. If the system found similar entries you categorised before, the same categories will be assigned to these entries but you still need to manually approve them.

If the uploaded transactions were added already to your books, go to the Categorised tab from the Banking. Then, find those transactions and click Undo. This will move them back to the For review section. You can now match them to the bills you entered and the duplicate entries will be fixed.

You can check this link: Categorise and match online bank transactions in QuickBooks Online. This will show you more details on what to do with the downloaded bank transactions.

Need help in balancing your account? Check this article for the steps: Reconcile an account in QuickBooks Online.

Leave a comment below if you have other questions. Thanks!

Construction_C · ‎August 02, 2021

Hi Alex

Thanks for your reply. It's not just that they are being categorised when I upload the credit card statement manually, its that they are actually creating an expense transaction. So then I have the bill that I've entered, plus the expense transaction that is being created when I manually upload the credit card statement. I don't know why the manual upload would create an expense automatically? I've attached a screen shot to show the two entries in my bank dashboard for matching. I'm also unsure what the correct way to get rid of the expense duplicate is?

John C · ‎August 02, 2021

Hi Construction_C Are there any banking rules that have been created that have the 'Auto-add' selected(you can view this in the menu on the left hand side if you select Bookkeeping and then select Rules and then look at the auto add section)? If you do not want that to happen and you can see on the rule it is selected go to edit on that rule and then toggle off the auto add and then save.

In regards to getting rid of a duplicate the best thing to do is exclude them as below in the banking section.

Go to the For review tab.
Select the checkbox for each transaction you want to exclude.
Select Exclude. Excluded transactions then move to the Excluded tab. They won’t be added to QuickBooks or downloaded again.

Any questions feel free to add them to this thread

Topics

Training

Community

Resources

Manually uploading credit card statements