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.
MJ1407
Level 1

Unable to reconcile AP aging and AP balance on balance sheet

Due to what I assume to be a currency conversion rounding error, I have a -0.01 Euro cent balance on my AP - Euro balance sheet account, but a zero balance in AP aging. In other words, the balance sheet shows that I have a 1 cent credit with my Euro vendor, whereas the AP aging report does not. This happened before my time, and I am unable to go back and address it retroactively. Whatever may have caused it in the past, I need to find a solution/ entry with today's date. My first thought was an AJE to wipe out the -1 cent on the balance sheet (credit to AP-Euro and debit to other or misc. expense), and while this indeed takes care of the balance sheet, it then shows a 1 Euro cent balance owed to the vendor on the aging report. Is there any way to solve the discrepancy between the AP-Euro and the aging report? 

2 Comments 2
ZackE
Moderator

Unable to reconcile AP aging and AP balance on balance sheet

Welcome to the Community, MJ1407.

 

You're correct, you can use a journal entry to go back in your records and correct the rounding for a currency conversion. Before doing so, I'd recommend working with an accounting professional to identify if this is the best course of action to correct your invalid data. If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

 

Here's how it works:

  1. Go to our Find a ProAdvisor page.
  2. Use the City or ZIP search field to specify a location.
  3. Select Find a ProAdvisor.
  4. Browse through your results and find one that works best for the business. You can click on each ProAdvisor's profile to learn more information about them.

 

Once you've found an accountant, they can be contacted through their Send a message form:

  1. Use the available text box to introduce yourself. Be sure to include details about which services you're looking for.
  2. Enter your appropriate info in the Your nameYour email, and Your phone number (optional) fields.
  3. Hit Send message.

 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

 

Please don't hesitate to send a reply if there's any questions. Have a wonderful day!

MJ1407
Level 1

Unable to reconcile AP aging and AP balance on balance sheet

Hi ZackE,

I'm sorry if this wasn't clear, but an AJE doesn't solve my problem. A credit to my AP-Euro account will remove the negative cent from the balance sheet, but it results in an unwanted balance owed to the vendor on the aging report. 

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

Need to get in touch?

Contact us