Transaction Detail by Account Report doesn't display Expenses for LFY to date setting

Legacy KB ID: 5042

Question

Why don’t entries to expense account in the previous financial year show on the Transaction Detail by Account Report when I select the date range: Last Financial Year to Date setting?

Answer

Generate 2 reports or set your Financial Year to encompass the date range of the data you wish to show.

The Issue

At the end of the financial year Accounts Business (previously QuickBooks) closes off income and expense accounts to the Retained Earnings account.  When you request a report for income and expense accounts that traverse two financial years, Accounts Business will list the Retained Earnings net amount for the previous financial year then list individually the entries in this financial year. 

If the details you want to see in the report lie within a 12-months span, you can view all transactions by adjusting the financial year for that 12-months span.

Detailed Instructions

Option 1 – Generate two reports

1. Report 1: set date range to Last Financial Year.
2. Report 2: set date range to This Financial Year-to-Date.

Option 2 – change the Financial Year to encompass the date range required.

1. Company > Company Information
2. Under Report Information > Financial Year > First month in your: select the first month of your desired report;
3. Click OK to Save;
4. Open a Transaction Detail by Account Report and select This Financial Year-to-Date as the date range;
5. When reporting is complete, return the Financial Year setting to its original month. 

Need more help?

Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts

Or Log a Support Ticket: https://www.reckon.com/au/support/