Daily Sale Report with C.Card Details
Navigate to Reports/Queries\Sale Registers and click on "Daily Sale Report with C.Card Details".
The Daily Sale Report with C.Card Details lists each day's sale bills by how they were paid: cash, credit, cheque, credit card and gift voucher. Card payments show the card number, card type, card account and the card holder's details; cheque payments show the cheque details; credit and cheque payments show the customer's details. Use it to tally each day's collections by payment type, and the card collections by card account.
Run the report
Choose a configuration (see Daily Sale Report with C.Card Details - Configuration).
Enter the date range.
Select Credit Card Account, Credit Card Number, Branch or Credit Card Types if needed.
Run the report.
At least one payment type must be ticked in the configuration — only the ticked payment types are listed and counted in the totals.
How a day is laid out
For each day (and each branch, when Branch Totals is ticked), the report lists the payments in this order:
CASH — cash bills with numbers running one after another in the same series are shown on one row as a range, from the first bill number to the last, with their amount and quantity added up.
CREDIT — one row per bill, with the customer's details.
CHEQUE — one row per bill, with the cheque details and the customer's details.
CREDIT CARD — one row per card payment. A bill paid with two cards shows two rows.
GIFT — one row per bill paid partly or fully by gift voucher.
A bill paid in more than one way (for example part cash, part card) appears under each of its payment types, each row showing the amount paid that way.
The columns
SNO.
the row number
BILL DATE, BILL NO.
the bill's date and number; for cash, a range of bill numbers
TYPE OF SALE
CASH, CREDIT, CHEQUE, CREDIT CARD or GIFT; on totals lines, the name of the total
BILL AMOUNT
the amount paid by that payment type
TOTAL QUANTITY
the bill's total quantity — see Quantity below
BRANCH NAME
the branch of the bill
CHQ/CC NO.
the cheque number, or the credit card number
CREDIT CARD NAME
the card type, for example VISA
CC ACCOUNT NAME
the account the card payment is posted to
CC DESCRIPTION, CC REFERENCE ID, CC REFERENCE NUMBER, CC TRANSACTION DATE, CC REQUEST REFERENCE ID
the details recorded against the card number. They belong to the card, not to the single payment, so every payment made with the same card shows the same values; CC REQUEST REFERENCE ID is the card's latest request
BANK NAME, BRANCH, CHEQUE DATE, ACCOUNT NO.
the cheque details. A bill paid only by cheque shows the cheque number and date; BANK NAME, BRANCH and ACCOUNT NO. are filled when the cheque was entered as one of the bill's payment lines
FIRST NAME, MIDDLE NAME, LAST NAME, HOUSE NO., ADDRESS, PHONE-1, PHONE-2, PAGER NO., MOBILE NO., MEMBERSHIP NO., CITY NAME, LOCATION NAME
the customer's details on credit and cheque rows; on card rows, the card holder's name, address, phone and city in FIRST NAME, ADDRESS, PHONE-1 and CITY NAME
REMARKS 1, REMARKS 2, REMARKS 3
the remarks entered on the bill
MIDDLE NAME, LAST NAME, HOUSE NO., PAGER NO., MEMBERSHIP NO. and LOCATION NAME are filled for a retail customer. For a bill made to a customer account, FIRST NAME shows the account's contact person, with the account's address, phones and city. Cash and gift rows do not show customer details.
Totals
Each total can be switched on in the configuration:
CASH TOTAL, CREDIT TOTAL, CHEQUE TOTAL, CREDIT CARD TOTAL and GIFT TOTAL after each payment type (Sale Totals).
CREDIT CARD ACCOUNT TOTAL for each card account within a day (Credit Card Account Wise Total). The day's card rows are then grouped by card account, in alphabetical order.
DATE TOTAL at the end of each day (Date Totals).
BRANCH TOTAL at the end of each branch (Branch Totals).
GRAND TOTAL at the end of the report (Grand Totals).
The date, branch and grand totals add up only the payment types that are ticked.
Sale returns
Sale returns are shown with a minus amount and a minus quantity, and are taken off the totals.
Example — one day at the Main Road branch
Asha pays ₹2,000 in cash for 2 pieces. Vikram pays ₹5,000 for 3 pieces: ₹1,000 in cash and ₹4,000 by card. Meena returns 1 piece bought earlier, worth ₹800, against a cash refund.
With every payment type ticked, and Sale Totals, Credit Card Account Wise Total and Date Totals ticked, the day shows:
CASH (Asha)
2,000
2
CASH (Vikram)
1,000
3
CASH (Meena's return)
-800
-1
CASH TOTAL
2,200
4
CREDIT CARD (Vikram)
4,000
CREDIT CARD ACCOUNT TOTAL
4,000
CREDIT CARD TOTAL
4,000
DATE TOTAL
6,200
4
The three cash rows show as separate rows here so the amounts can be followed; when the bill numbers run one after another in the same series, the report shows them on one row as a range. Vikram's quantity is shown once, on his cash row, and left blank on his card row.
Quantity
TOTAL QUANTITY is the whole bill's quantity. A bill paid in more than one way shows its quantity on one of its rows only — the cash row if there is one, otherwise credit, then cheque, then gift voucher, then card — and leaves it blank on its other rows, so each bill's quantity is counted once in the totals. Payment types that are not ticked are skipped when choosing that row.
Good to know
Selecting a Credit Card Account lists only bills that have a card payment. The card rows are limited to the chosen accounts; the same bills' cash, credit, cheque and gift rows are still listed.
Credit Card Number and Credit Card Types limit only the card rows. The cash, credit, cheque and gift rows of every bill in the date range are still listed.
When branch rights apply to reports, you see only the branches you have rights to.
With Branch Totals unticked, the rows run date by date across all the chosen branches, with one DATE TOTAL per day.
Within each payment type, rows run in bill-number order. A bill paid with two cards lists its card rows by card account.
A zero amount or quantity is shown blank.