x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 111 subscribers
  • Views 1040 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
44
topics
90
replies
Payroll, Time Tracking, and Job Cost
776
topics
1k
replies
Reporting and Analytics
960
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
Jane_Li

How to find the cause of variance between invoice total and the number on income statement ?

SOLVED
Posted By

Hi,

I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total is off by $7.45 and May is off by $35.00. Can anyone give me some clue on how to find out the cause for this discrepancy ??? 

Highly appreciated,

Jane 

Parents
  • 0

    I would suggest writing a Crystal Report on the AR Invoice History Header and Detail files and the GL Account file. Detail should be on the left.  Link the GL file to the detail file linking on the Sales Account Key.  Set a date range for that one month.  Group, sort and total by the  Sales Account Key in the Detail file.  This should show you which GL account you left out and where the totals are off.

Reply
  • 0

    I would suggest writing a Crystal Report on the AR Invoice History Header and Detail files and the GL Account file. Detail should be on the left.  Link the GL file to the detail file linking on the Sales Account Key.  Set a date range for that one month.  Group, sort and total by the  Sales Account Key in the Detail file.  This should show you which GL account you left out and where the totals are off.

Children
No Data

*Community Hub is the new name for Sage City