Please use the excel sheet for the data comparison
(A) To get the data,go to Supplier > Creditors > Historical AP Balance.
- Select the company,date ( for opening & closing) & generate report.
- After generating report click on GL code,so all the GL code are arrange in sequence.
- Take the balance amount for one time supplier,accPayable & otherPayable(credit or debit amount) & compare it with Balancesheet & supplier historical transaction ageing.
(B) For Balancesheet go to Accounting > Financial statement > Balancesheet.
- Select the Company,Date for opening & closing & Generate Report:
(C) To get the data,go to Supplier > Creditors > Supplier Historical Transaction Aging Analysis.
- Select company,branch & date for opening & closing & generate report.
- Compare the amount of Aging Summary with balancesheet & historical AP balance.