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-month span, you can view all transactions by adjusting the financial year for that 12-month span.

If the details you want to see extend over more than a 12-month period, then you will not be able to get all the details on the one report.

 

Detailed Instructions

Option 1 – Generate two reports

·         Report 1: set date range to Last Financial Year;

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

You can if you wish export the reports to Excel and use Excel functions to merge the two reports. 

 

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

Please Note: this option applies only where the relevant data falls within a 12-month period. 

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. 

 

 

How did we do?

Can't email job statements in QuickBooks.

Printout of Employee Bank Account details from Reckon Accounts

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)