Standard AP Aging Report vs Balance Sheet Our total in the standard AP aging report vs AP balance in the balance sheet isn't equal although we are both viewing them as of the adjustment period (by period not Transaction Date).

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The discrepancy between the standard AP aging report and the AP balance in the balance sheet could be due to several reasons: 1. Manual Journal Entries (JEs): If you have manual JEs in your balance, these are excluded from the AP aging report. 2. Individual Settings: Check your preferences and ensure you are viewing as "financial only". 3. Date/Period Mismatch: Financial reports, like the balance sheet and trial balance, are based on the posting period. The aging reports, by default, are based on the transaction date. If you allow a date/period mismatch, you'll have variances. You can change Aging reports to be based off transaction date or due date in Accounting preferences. 4. Accounts Included in the Report: The standard AP aging report includes ALL accounts of account type "Accounts Payable”. Add a filter to filter for only the AP account that matches to the B/S account you want to see. If you've tried all these and the balances still don't match, you may need to trace the earliest period with discrepancy and manually trace the discrepancy per entity. Regarding the question about showing all transactions including paid bills in the AP aging report, the AP Aging report is designed to show only unpaid bills in AP. Closed transactions are not typically included in this report. Lastly, if the account selected for Debit and Credit are both AP account, then it won't show up in Aging Report. This is because the Aging Report is designed to show the outstanding balances, not the transactions between the same account type.