There must be more than the 2 you have listed.

AP balance is 281.43 more than the list of AP outstanding - either an invoice (or several) that adds to 281.43 was not entered in history mode or the AP balance account was unlinked to make an entry without going thru A/P modules or you posted a purchase invoice right when there was a power outage etc.

To look for the difference - how about exporting AR balance account to Spreadsheet at a specific date and put in alpha order to match against aged AP at same date.

Or type in the Quick Search bar the amount of 281.43 to see if that pops up anywhere.

Same goes for Vac pay balance which is 381.20 less than the total of all employees outstanding vac pay.

You must be out 99.77 somewhere in the integrity check box - maybe AR?

I presume you mean ..exporting AP balance account...',

reports->financials->GL for the AP account (2100) for this fiscal year as of today

export to excel, sort by comment (vendor) and compare the open balance for each vendor to

reports->payables->aged overdue payables as of today (summary)

I ran a balance sheet as of May 1,2007 (first date) - ap = 42,000

aged overdue payables as of same date = 0

I presume this means they entered the account balances in historical mode, but not the outstanding invoices

could this be the root cause of the data integrity mismatch

doesn't dbutil rebuild this ?

If details have been cleared, or customers / vendors deleted, you won't be able to run past period reports to check them against the GL.

I don't think they could have gotten out of historical entry mode with a $42,000 imbalance, possibly they didn't set the payables up until a later period.

If details have been cleared, or customers / vendors deleted, you won't be able to run past period reports to check them against the GL.

I don't think they could have gotten out of historical entry mode with a $42,000 imbalance, possibly they didn't set the payables up until a later period.

ok.. so I ran an AP ledger report for the past fiscal year, there's a vendor with two transactions (250$ payment in Jun 2013 and 1000$ invoice in Mar 2014) - but the AP aged payable summary only shows the 1000$ invoice

as outstanding

the payment is applied to an invoice in the prior fiscal year

I'm concerned that comparing the totals of these two reports by vendor (GL ledger for the AP account and AP aged payable summary) won't allow me to find the data integrity error(s)

or am I using the correct reports, just totaling incorrectly ?

If prepayments made and linked to a prepayment account nbr then the formula seems to be Aged payable total less outstanding prepayments equals 2100 Acct Pay. I wonder if you have a prepayment account that would tie into your situation.

Also if invoices were posted as purchases with payment then it will not show up in the 2100 acct. Have you been able to double click on a few invoices to see how it was posted?

If I remember correctly one cannot advance into a new fiscal year with an imbalance in data integrity (at least this should not be allowed).