I import an excel with my payroll transactions. Credits cash and debits relevant Tax accounts and we ACH the cash amounts to our payroll provider.
However, this time, the payroll girls transferred the cash amount back to our main checking account and sent the ACH from the MAIN account instead of the payroll account. So now in my excel import I have all the numbers correct but I also have a transaction of money coming into my MAIN account and also being ACHd from there.
How do I account for this in a journal entry? My payroll account already has the relevant Credit to cash as part of the excel journal entry we imported.
So I am thinking that I make a debit and a credit to the MAIN account to show the money coming INTO the MAIN acct and also LEAVING the MAIN account. Because if I matched a transfer then it would show an additional movement on the Payroll Account when that money is already showing as Credited through the Excel import.
I don't want to make a transaction in my MAIN account that touches any of the tax or payroll accounts because those are all correct from the Excel import of payroll. I really just want to show the amount leaving the MAIN account to our payroll provider.
Am I overthinking this?
