mibuso.com

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!

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

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!

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.

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

Done.

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.

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

Alex:

Yeah, use it as you see fit.