Sales data summarized by GL account

leewhite1234 · 2007-03-09

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 · 2007-03-09

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

leewhite1234 · 2007-03-09

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 · 2007-03-09

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 · 2007-03-09

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

Alex_Chow · 2007-03-09

leewhite1234 wrote:

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

Done.

Savatage · 2007-03-14

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 · 2007-03-14

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

Alex: =D> =D>

Alex_Chow · 2007-03-14

Yeah, use it as you see fit.

Howdy, Stranger!

Quick Links

Categories

Sales data summarized by GL account

Comments