cancel
Showing results for 
Search instead for 
Did you mean: 
tex-mex
Level 1

How to reconcile / match 2 duplicate expenses?

My payroll provider (Gusto) automatically creates journal entries for payroll that breakdown / split payment into it's constituent parts (taxes, payroll).

 

Let's say I pay $10,000: Gusto will create a journal entry with $8,000 payroll, $2,000 tax. 

 

My bank is debited $10,000 in whole (one transaction charge). I upload bank statements manually.

 

Under my expenses, I am debited twice: $10,000 ($8,000+$2,000 breakdown) from the Gusto integration, and $10,000 again when it appears on my bank statement.

 

How do I reconcile this? Do I just 'exclude'  the bank transaction? 

 

 

 

 

 

 

 

1 Comment 1
JonpriL
Moderator

How to reconcile / match 2 duplicate expenses?

Hello @tex-mex,

 

You don't have to exclude your transactions. Let me help share how you can categorize and reconcile your bank transactions after uploading them.

 

Normally, you can match a downloaded bank transaction to multiple entries as long as your existing expenses have the exact total amount and date.

 

In the same manner, here's an article you can read to learn more about reviewing and matching your downloaded transactions: How to review downloaded bank and credit card transactions and put them in the correct accounts?

 

On top of that, I've also included this reference for a compilation of articles you can use while working with us: Banking for QuickBooks Online.

 

If there's anything else that I can help you with, please let me know in the comments below. I'll b here to lend a hand.

Need to get in touch?

Contact us