X & Z Reports vs. Sales Payment Spreadsheet |
Go Back to List of FAQs Previous Next |
X & Z Reports vs. Sales Payment Spreadsheet
Below are descriptions of the figures that appear on the X and Z-Reports.
While the X and Z reports can be useful in balancing the register or cross-checking the sales reports at the end of the day, we strongly advise not using them for any official reporting.
We suggest you use the Itemized Sales reports for sales reports and sales tax reports (without concern for payment details), and the Sales Payment Spreadsheet for cash register activity. Those reports identify each element Note that the X/Z reports don't consider dates in any way. They contain just what was physically typed in since the last Z report.
If there's a difference between the X/Z Report and the Payment Spreadsheet, it's worth taking a closer look (which could affect the X/Z report layaway figures).
In general, if the sale and the payments look fine for the day on the Payment Spreadsheet, that's the more official one because it shows the contents line by line. See notes here about running a sales tax report. http://www.jewelryshopkeeper.com/help/vjs/faq/?sales_tax.htm
CHARGES Total amount of all (positive) charge account sales made for the day. For instance, if you totaled all of the charge account receipts, even those that were later voided because they were mistakenly entered or the customer changed his or her mind.
CHARGES VOIDED Total of all charge account sales that were voided or which were returns.
NET CHARGES TODAY The net total amount of the day's charge account sales. This equals CHARGES minus CHARGES VOIDED.
REC'D ON ACCOUNT The total amount of payments from charge account customers, including partial payments made on sales, and checks that were sent in with the statements.
REC'D ON ACCOUNT VOIDED The amount of payments received from charge account customers that were voided or had a negative total because they were mistakes or the customer changed her mind.
NET REC'D ON ACCOUNT TODAY The net amount of payments received from charge account customers. This equals REC'D ON ACCOUNT minus REC'D ON ACCOUNT VOIDED.
PREVIOUS OUTSTANDING CHARGES The total amount that all of your charge account customers owe you as of the last time the ZþReport was run. If this number is incorrect, you can adjust it from the Update To-Date Figures option from the Cash Register Maintenance menu.
NET CHARGES TODAY The net total amount of today's charge account sales. This equals CHARGES minus CHARGES VOIDED.
NET REC'D ON ACCOUNT TODAY Restatement of the field above by the same name.
CHARGE ACCOUNT ADJUSTMENTS TODAY The total of any adjustments made to the charge accounts. This includes debit and credit memos and also finance charges assessed on the customers will appear on the day that accounts receivable aging is performed.
TODAY'S DEFERRED CHARGE CARD PAYMENTS The total of charge-card payments such as American Express on which the actual payment to you is deffered. These amounts are posted to the charge account of that charge-card if you set up a charge account for the card and setup the card in the Store Information Defaults.
NET OUTSTANDING CHARGES The total of the accounts receivable, taking today's charge account activity into account
PREVIOUS OUTSTANDING LIABILITIES The total amount of outstanding deposits, as of the last ZþReport, that customers have made on layaways and special orders. This represents an amount you potentially owe the customers.
NEW LAYAWAY/ ORDER LIABILITIES TODAY The total amount of deposits that customers have made on layaways and special orders for the day. This increases your liability.
TODAY'S LIABILITY REDUCTIONS The amount of deposits on layaways and special orders that you previously owed customers but no longer do because the customer completed the sale and picked up the items. You no longer owe these customers this amount because they have now taken possession of the item.
NET OUTSTANDING LIABILITIES The total amount of outstanding deposits, including today's activity, that customers have made on layaways and special orders. The open layaway sales that comprise this total can be reported by running the Layaway & Special Order Report in the Sales menu. The subtotal for Amount Paid will equal the Net Outstanding Liabilities.
FINALIZED LAYAWAYS/ORDERS The total amount of layaways and special orders that only today were paid off and picked up by the customer. Only now are they included in the sales total; they are not included when only a deposit is made on them. The full amount of the sales is included here even if only a small amount of money was received today.
GROSS CASH The total of all regular sales receipts today, where the customer paid for the item in full by any payment method. This figure even includes those sales which were subsequently voided out.
CASH SALES VOIDED The total of all regular sales that were entered into the Jewelry Shopkeeper today, but were subsequently voided out. This also includes any return sales.
NET CASH SALES TODAY The net amount of today's regular sales. Gross cash sales minus cash sales voided.
NET CHARGES TODAY The net total of all items that were bought today on charge accounts.
TOTAL SALES TODAY The total amount of all 'regular' sales, charge account sales and those layaway and special orders sales which were finalized today.
PREVIOUS SALES The total amount of all items bought to date as of the last ZþReport. If this number is incorrect, or you want to reset it, you can adjust it from the Update To- Date Figures option from the Cash Register Maintenance menu.
TOTAL SALES TO DATE Previous Sales plus Total Sales Today.
PAID OUT The amount of petty cash that was taken out of the cash register today.
RECEIVED The amount of money that was put into the till today that was not related to a sale. This might be change from a paid- out from a previous day or earlier today, or an unusual receipt of money þ perhaps the owner putting money into the cash register.
NET PAID OUT TODAY The net amount of money that went out of the cash register today on paid-outs and cash received.
NET CASH SALES TODAY Restatement of the field above of the same name.
DEPOSITS RECEIVED ON AN EARLIER DATE This represents that portion of today's cash sales which was paid with a deposit on a previous date. Although the entire sales amount was included in today's sales total, the full amount will not be in the cash register today.
NET REC'D ON ACCOUNT TODAY Restatement of the field above of the same name.
LAYAWAY / ORDER PAYMENTS REC'D TODAY The amount of money accepted today as deposits on layaways and special orders. This includes both the initial deposits and any additional deposits that might have been made. This amount does not appear in the sales total, but should appear in the cash register.
MONEY RECEIVED FOR GIFT CERTIFICATES TODAY The amount of money accepted today for the purchase of gift certificates. This amount does not appear in the sales total, but should appear in the cash register.
GROSS CASH TODAY The amount of money that you received from customers today.
NET PAID OUT TODAY Restatement of the field above of the same name.
TOTAL NET CASH TODAY The total amount of money (or money equivalent) that should be in the cash register today, excluding the float.
CASH COUNT Write in the total amount of money that you count from the register, excluding the float.
OVER Write in the amount by which the register is over, if any.
SHORT Write in the amount by which the register is short, if any.
CURRENCY & COINS The amount of cash in the register.
CREDIT CARD PAYMENTS The number of credit card payments, and the total amount paid by credit card.
CHECKS The number of checks received, and the total amount received in checks.
CREDIT SLIP / GIFT CERTIFICATES USED The number of credit slips and/or gift certificates used, and the total amount paid by credit slip or gift certificates.
COMPANY CHECKS ISSUED FOR REFUNDS The number of checks issued for refunds, and the total of those checks.
TOTAL NET CASH The total cash that should be left in the register.
CURRENCY & COINS (DEPOSITABLE) The cash and coins available to be deposited in to your bank account.
CREDIT CARD (MINUS DEFERRED) PAYMENTS (DEPOSITABLE) Some credit cards payments arenþt deposited instantly to your account. These are referred to as Deferred Payments. Only the credit card payments minus the charge companyþs service charges are included in this total. |