Troubleshooting: Monthly Sales Analysis amount different from Cash Sales Listing

From AutoCount Resource Center

Question: When I compare Monthly Sales Analysis to Cash Sales Listing report, the total amount for May’22 are not matched. Why?

  • I did not filter anything and already ticked show in Local Currency.
  • Cash Sales listing and Cash Sales Detail Listing local totals are the same.

Version: 1.8 / 1.9 / 2.0

Footer amt not include1a.png


Footer amt not include2.png


Footer amt not include3.png


Footer amt not include4.png


Possible Reason:

In footer maintenance, “Add this footer value for Sales/Purchase Analysis” is not enabled.


Solution:

1) Go to General Maintenance > Footer Maintenance, edit the related footer and check the “Add this footer value for Sales/Purchase Analysis” and click on OK.

Footer amt not include5.png


2) You may try to filter by date for both reports to compare and find out which document has caused the totals different. Once located the document, edit it and retype the footer amount and save by selecting previously used payment mode.

Footer amt not include6.png


3) If there are too many documents, you may login AutoCount Management Studio, go to Data Consistency > Repost Sales/Purchase/Stock Transaction, filter the specific transaction date, check the Cash Sale document and check ‘Re-calculate the Net Total and Local Net Total’, then Start Repost.

Footer amt not include7.png


4) The total in Monthly Sales Analysis will be the same as Cash Sales Listing report.

Footer amt not include8a.png


By: Park Yao 220615, Lay Swan 220627, P220629


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations