• rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Topic: GL Accounts Transactions Totals Between two dates

The GL Accounts Transaction report asks the user to input Start Date and End date for a certain GL account. The resulting report shows the opening Balance and the Ending Balance for that period and all transactions in the middle. I would like to see the total credits/debits for that account in the specified period. I know one can do the math of Ending Balance minus Opening balance and then one gets the totals.. But then I have to do that manually. How easy it is is to incorporate it in the report? Running FA2.4.4.

rafat's Website

2 Reply by poncho1234 (edited by poncho1234 08/30/2018 04:36:39 pm)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: GL Accounts Transactions Totals Between two dates

There are two reports in Banking and General Ledger -> General Ledger Reports that have a column total for period selected by individual GL account.

The column headings are This Period and Period

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: GL Accounts Transactions Totals Between two dates

Sorry but I only see one report in Banking and General Ledger -> General Ledger Report -> GL Accounts Transaction
Other than that?

rafat's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: GL Accounts Transactions Totals Between two dates

There are nine reports for Banking and General Ledger, as you only have one, check your access rights.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: GL Accounts Transactions Totals Between two dates

@rafat

If you only need to see the total debits and credits you can use the Trial Balance Inquiry in Banking and General Ledger and the trial Balance Report in General Ledger Reports. They will show the total debits and credits for the selected period.

/Joe

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: GL Accounts Transactions Totals Between two dates

Ok.. Thanks

rafat's Website