Account Entries Report

Created by Natasha Dubauskas-Reed, Modified on Mon, 14 Nov 2022 at 01:06 AM by Allison Cloyd

This article explains the account entries report.

The account entries report shows a list of entries for a selected account in the general ledger for a certain period. The report can be run for multiple general ledger accounts and all general ledger accounts for a period of time. 

 

Configurations

/helpdesk/attachments/150002488349

 

Option Description
Date Range This is the date range of the transaction date. These dates will determine which transactions will be included based on date. 
Account This is a required field and you must choose a general ledger account or multiple general ledger accounts. 
Include Detail of Header Accounts

When this box is ticked if the general ledger account(s) is a parent account that you have chosen in the account box above. Then all the children of these account(s) will also be displayed. 

Filter by Matter(s) You can select one or multiple matters. Only trnsactions which reference these matters wil be displayed in the generated report. 
Transaction Reference

You can select ONLY one transaction reference to include transactions of this reference type. 

 

/helpdesk/attachments/150002488350

Reference Value  
Show references  
Retained Earnings  
Show Their Reference  
Group by Transaction  

Report Generation

When the report is generated you can click on the transaction ID in the left column to get the details of the full general ledger transaction.

 

/helpdesk/attachments/150002488351

Output

/helpdesk/attachments/150002488352

 

Option Description
Print Bring up your print dialogue 
Excel Downloads the balance sheet in an XLS format
PDF Downloads the balance sheet in a PDF format

 

FAQ's

Q. I want to run an account entries report on all my transactions across all general ledgers but I dont wan tto have to pick every single GL account?

A. Go to Accounting > Accounts > Account List go to display and select master accounts (this makes it a little easier to see the header accounts). You can select all the accounts in bold OR you can select the main header accounts for example, in the screenshot below this would be Assets and Fixed Assets.

/helpdesk/attachments/150002488353

 

Add these accounts to your search and make sure to tick inlcude deatil of header accounts (this actually includes details of the child accounts). 

This will generate a report with every account listed under the header accounts included. 

/helpdesk/attachments/150002488354

Q. I want to include the entrire financial year of transactions however it will not load?

A. Unfortuantely there may be too many transactions to run this length of time in one report try narrowing down your search to six months or three months or one month at a time.