GL Account Detail Export

The GL Account Detail Export allows the User to drill into all transactions associated with a specified account(s).

This report also uses hyperlinked reference numbers that show their respective transaction entries in a new tab.

Navigation

To navigate to the GL Account Detail Export, click 'My Reports' under 'Reports' in the left pane and select 'Financial' in the top header of the reporting window. Once opened, a listing of reports will be shown. 

Find 'GL Account Detail Export' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.

Report Parameters

1. Accounts Available - A listing of all GL Types

2. Account - A listing of all GL Accounts

3. Parent - This option either shows or hides Subaccounts of each Parent Account

4. Filter By - A listing of all Location categories

5. Filter - A listing of all Locations associated with the selected Location category

6. Start Date - The beginning date for the report 

   R365 Best Practice
   Due to the large volume of data in the GL Account Detail Export, it is recommended to run this report in quarterly segments to prevent timeouts and ensure successful exporting of data.
   

   Users can also use the OData connector for flexible data extraction and reporting.

7. End Date - The end date for the report 

8. Show Unapproved - These options will either include or exclude Unapproved transactions

9. Calendar - These options allow the User to view GL Account Details based on a specific calendar

10. Sum by Transaction - When 'No' is selected, GL Accounts show more details if more than one transaction was made to that account

11. Include Stat Accounts - This will either include or exclude Statistical Accounts in the report

12. Hide Zero Balances - This will either show or hide zero balances in the report

13. Exclude GL W/Out Activity - This will either include or exclude GL Accounts in the report that do not have any activity for the date range selected

14. Include Ref Links - When set to 'No', the transactions listed in the 'Ref. Number' column will not be hyperlinked to the associated transaction.

15. Run Button - Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action. Click here to learn more about this functionality

Click here to learn more about Report Views and their added functionality.

Report Columns

1. Date - The date of the transactions broken down by GL Accounts and Locations

2. Type - The type of transaction

3. Ref. Number - The number that is connected to the transaction. When this hyperlinked number is clicked, the transaction details will open up in a new window

   When the 'Include Ref Links' Report Parameter is set to 'No', 'Ref. Number' will not be hyperlinked to the associated transaction.

4. Company - The name of the Vendor that is connected to the transaction

5. Location - The restaurant Location that received the transaction

6. Comment/Item - Any comment or Quantity per Each Amount written in the transaction details

7. Debit - The amount the account is increased

8. Credit - The amount the account is decreased

9. Balance - The amount remaining for each GL Account by the addition and withdrawal of funds from each Account's transactions

Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.