cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
jlfliberty
Level 1

Journal Entries to correct Accounts Receivable Balace

QB Novice here.

Are there Journal entries to correct accounts payable and receivable to zero without affecting my Income and expenses or other balances?

I have an accounts payable balance that is negative when I check the beginning of the year Jan 1, 2020. That does not make sense to me since I owed nothing at the beginning of the year and is probably due to my errors for 2019 QB.

I also have accounts receivable balance at 2020 year end and No money is owed to me.

Are there Journal entries to correct these balances to zero without affecting my Income and expenses or other balances?

4 Comments 4
Rustler
Level 15

Journal Entries to correct Accounts Receivable Balace

No there is not.

 

Do not use the chart of account to check, use the balance sheet.  A positive on the balance sheet mean you owe money, and a negative means you are owed money.  This type of mismatch usually comes from using enter bills, and then not using pay bills as you are required to do so. Using pay bills clears the a/p entry

 

same kind of thing for a/r, positive on the balance sheet means you are owed money, negative means you owe or have customer credits.

jlfliberty
Level 1

Journal Entries to correct Accounts Receivable Balace

Thank you for the response. It is rather perplexing, I am not an accountant however I have worked as a systems/analyst programmer for 40+ years of which the last 23 years supporting an older double entry accounting system on a i Series IBM. Anything can be corrected via Journal Entry. I assume some older technologies are more flexible than newer. I take it that I will have to go back through 2019 through 2020 in order to change every transaction to follow the ridged or inflexible guide lines of Quick-books. Tax extension deadline has already been missed so I was looking for a quick correction but if Quick-books is does not have the capability then there is nothing that can be done.

QBsguru
Level 7

Journal Entries to correct Accounts Receivable Balace

The balances you have showing are probably caused by incorrect entries in QuickBooks in a prior year.  You can correct with a journal entry, but the other side of the entry would be a P&L adjustments.  For balances in Accounts Receivable, this is likely caused by entering a deposit and coding it to an income account rather than receiving a customer payment and applying the payment against the invoice.  This results in doubling up of income (once for the invoice and a second time for entering the deposit).

 

As for accounts payable, one of two things happened.  Either the a check was written and coded to accounts payable or a bill was deleted after the vendor bill was paid.  Either way, you have understated expenses. 

Rustler
Level 15

Journal Entries to correct Accounts Receivable Balace


@jlfliberty wrote:

 Anything can be corrected via Journal Entry. 


 

Journal entries in QB can be problematic, often they do not work as intended and even more often they do not show in reporting.  I have no idea why that is, but is has been true since 2006 when I started with QB.  So can you use them, sure you can.  But to insure they work as planned you need to check all reporting that might use the accounts involved, screen displays of account history is not always the same as a report.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us