Sales Report vs. Tender Report

Posted by Zorian on March 5, 2007, 7:47 am

Please log in for more thread options

I performed a Sales report for 2006 and for the first time ever (in almost 2
years) ran a Miscellaneous/Tender report just to see how much was in cash, in
check , in CC, etc. But then I noticed that the totals for the Tender were
almost 20% below the total Sales shown on the Detailed Sales report for all
of 2006. This was a really large discrepancy and I cannot figure out what
the totals would not be equal, never mind that they are this different.

Can anyone guide me in figuring out why there is such a huge difference
between a Sales report and Tender report for exactly same period of time?

Posted by Craig on March 5, 2007, 10:02 am

Please log in for more thread options

Maybe the Tender reports have tax and deposits figured in.
Craig

>I performed a Sales report for 2006 and for the first time ever (in almost

> years) ran a Miscellaneous/Tender report just to see how much was in cash,

> in

> check , in CC, etc. But then I noticed that the totals for the Tender

> were

> almost 20% below the total Sales shown on the Detailed Sales report for

> all

> of 2006. This was a really large discrepancy and I cannot figure out what

> the totals would not be equal, never mind that they are this different.

> Can anyone guide me in figuring out why there is such a huge difference

> between a Sales report and Tender report for exactly same period of time?

Posted by Nashat on March 5, 2007, 11:40 am

Please log in for more thread options

: quoted-printable

what about work orders and layaways that r not fully paid? if u receive =
a down payment, the transaction will affect the sales report with the =
total amount, but the tender report will be affected by only the =
payments u received

>I performed a Sales report for 2006 and for the first time ever (in =

almost 2=20

> years) ran a Miscellaneous/Tender report just to see how much was in =

cash, in=20

> check , in CC, etc. But then I noticed that the totals for the Tender =

were=20

> almost 20% below the total Sales shown on the Detailed Sales report =

for all=20

> of 2006. This was a really large discrepancy and I cannot figure out =

what=20

> the totals would not be equal, never mind that they are this =

different.

>=20

> Can anyone guide me in figuring out why there is such a huge =

difference=20

> between a Sales report and Tender report for exactly same period of =

time?
------=_NextPart_000_001B_01C75F55.B2774BD0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>what about work orders and layaways =
that r not=20
fully paid? if u receive a down payment, the transaction will affect the =
sales=20
report with the total amount, but the tender report will be affected by =
only the=20
payments u received</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Zorian" <</FONT><A=20
size=3D2>Zorian@discussions.microsoft.com</FONT></A><FONT face=3DArial =
size=3D2>>=20
wrote in message </FONT><A=20
face=3DArial=20
A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>>I =
performed a=20
Sales report for 2006 and for the first time ever (in almost 2 <BR>> =
years)=20
ran a Miscellaneous/Tender report just to see how much was in cash, in =
<BR>>=20
check , in CC, etc.  But then I noticed that the totals for the =
Tender were=20
<BR>> almost 20% below the total Sales shown on the Detailed Sales =
report for=20
all <BR>> of 2006.  This was a really large discrepancy and I =
cannot=20
figure out what <BR>> the totals would not be equal, never mind that =
they are=20
this different.<BR>> <BR>> Can anyone guide me in figuring out why =
there=20
is such a huge difference <BR>> between a Sales report and Tender =
report for=20
exactly same period of time?</FONT></BODY></HTML>

------=

Posted by butch on March 8, 2007, 9:35 pm

Please log in for more thread options

Have you had RMS crash on you during a transaction? I have had
occurances where Transactions get "Orphaned." A Transaction record and
a transactionentryrecord get written, but no tender information is
recorded. Typically the cashier has not finished the transaction and
simply rerings everything. This makes any report based on the
transaction tables(Detailed sales report for example) show inflated
sales. Then other reports that are based on Tender records show more
accurate sales.

For us, accounting began seeing the discrepancy right away and I was
able to track down what was causing the issues. We then put measures
in place where by accounting compares the sales from Detailed sales
reports and Tender reports daily. I then run a query if there are
discrepancies to show me orphaned records. I research whether there is
a journal entry for the record I can view and whether it is safe to
delete the orphaned records. I have a trigger on the Transaction and
TransactionEntry Tables that records the delete trans records in case
I need to bring them back.

The queries that show me the orphaned records are:

DECLARE @STOREID INT
DECLARE @BeginDate Varchar(20)
SET @STOREID=614006
SET @BeginDate='1/1/04'

select *
from [TransactionEntry] where storeID=@StoreID and transactionnumber
in
(select T.TransactionNumber
from [transaction] T
left Join TenderEntry te on T.StoreID=TE.storeID and
T.Transactionnumber=TE.transactionnumber
where TE.[ID] is null and T.Total<>0 and Time >@BeginDate and
t.StoreID=@StoreID)

select *
from [Transaction] where storeID=@StoreID and transactionnumber in
(select T.TransactionNumber
from [transaction] T
left Join TenderEntry te on T.StoreID=TE.storeID and
T.Transactionnumber=TE.transactionnumber
where TE.[ID] is null and T.Total<>0 and Time >@BeginDate and
t.storeID=@StoreID)

I am not sayig this your issue, but it is something to look into.

Posted by john on April 2, 2007, 10:18 pm

Please log in for more thread options

You might also look at the amount of money you open and close your register
with. The amount needs to be subtracted from the tender report to compare it
with your sales report.
--
john

"Zorian" wrote:

> I performed a Sales report for 2006 and for the first time ever (in almost 2

> years) ran a Miscellaneous/Tender report just to see how much was in cash, in

> check , in CC, etc. But then I noticed that the totals for the Tender were

> almost 20% below the total Sales shown on the Detailed Sales report for all

> of 2006. This was a really large discrepancy and I cannot figure out what

> the totals would not be equal, never mind that they are this different.

> Can anyone guide me in figuring out why there is such a huge difference

> between a Sales report and Tender report for exactly same period of time?

Sales Report vs. Tender Report - large difference