Sales data summarized by GL account

leewhite1234

Is there a report that summarizes all sales data by GL account for a given period? I have a client who wants to reconcile sales activity to the GL, and I am not sure how to go about this.

Please help!

Savatage

personally all our sales goes into 1 G/L Sales account, But have you tried using the Trial Balance Detail/Summary Report?

leewhite1234

Yes, I've used that report, and then the summarized version to see activity for the month (net change). The client is accustomed to seeing something like the Daily Invoicing report with a breakdown of GL accounts, which they reconcile to the GL. What I'm really looking for is a monthly reconciliation procedure of how to tie the sales transactions to the GL. The Daily Invoicing Report doesn't have a total which ties to a single GL account, including the AR asset account. Am I missing something here?

Thanks for any help!

Alex_Chow

You need to create this report.

For our clients, we modified the Daily Invoicing report to have a breakdown by G/L account at the end of the report.

If you guys are interested in this report, I can upload it to the download area.

leewhite1234

Yes! Please post to the download area. This would be fantastic. Thanks.

Alex_Chow

leewhite1234 wrote:

Yes! Please post to the download area. This would be fantastic. Thanks.

Done.

Savatage

Great Job Alex - I will find this very useful too.

We don't use "Amount Including VAT" so I replaced it all with "Amount Including Tax" and all is fine.

ssingla

Thats a great report. Will give it for free in every implementation if Alex don't mind.

Alex: =D> =D>

Alex_Chow

Yeah, use it as you see fit.