Balancing Reported Sales Figures to GL Control Accounts

  • Sales statistics, as reported by SA70 and various sales reports, are updated by program IN43. The associated GL control account(s) are updated by IN44. Be sure IN43/IN44 have both been completed before trying to reconcile.

  • Using GL45, check the source of the detail postings to the Sales control account. The only expected source is from IN (Invoice Register). Postings from any other sources would have updated the control account but not the sales statistics.

  • Check that the correct GL control accounts are set up in CC00-IN2.

  • Check that none of the supplementary charges defined via IN01 are distributing to a sales control account. Supplementary charges update the GL but do not update sales statistics.

  • When posting a miscellaneous "**" supplementary charge, the invoicing operator is allowed to enter the desired GL account for distribution. Check to see that a sales control account has not been used. To check this, compare the "Daily Total" for Sales on IN44 (Invoice Register) to the sum of the GL distributions to sales control accounts reported on the last page of that report. If a supplementary charge was distributed to a sales control account, they will be different.

  • If there are any distributions to "x" accounts on the Invoice Register, those are sales distributions posted to a bogus GL account. They need to be journalized to the correct sales control account (and the GL interface needs to be corrected in CC00-IN2 to stop future postings to the "x" account).

  • Note: Total sales reported on the Commission reports could be higher than the value reported on all other sales reports if you process split commissions.

 
Back