Post-Diwali accounting means checking every festive sale, payment, purchase, and stock item once the rush ends. Reconciliation means matching two sets of records to check that they agree. You match your records, find gaps, and fix them with proof. This Diwali reconciliation checklist shows each step in simple order. Quick action stops small errors from growing. It gives you correct profit, stock, and cash figures for the coming months.
Verify sales and billing records
Festive season accounting starts with sales. Check your sales first, as they help you check everything else.
List all bills made during Diwali. Include cash sales, credit sales, online orders, and shop sales. Then check these points:
- Invoice numbers: They should run in order. If 1044 is missing, find out why.
- Duplicates: Look for the same customer, date, and amount entered twice.
- Cash sales: Compare the daily cash total with the cash in the till. Make sure every page of the handwritten bill book is in the system.
- Credit notes: A credit note is a document that reduces a customer’s bill, usually for a return. Each return needs one.
- Cancellations: Mark a cancelled bill as such. Do not delete it. Note the reason.
- Tax details: Check the GST rate and amount on each bill. Gift packs and combo sets often go wrong.
|
What you find |
Likely cause |
What to do |
|
Missing invoice number |
Cancelled, lost or unrecorded sale |
Find the bill or note the reason |
|
Bill entered twice |
Data-entry slip |
Cancel the extra entry |
|
Cash does not match till |
Missed bill |
Recount and check the bill book |
|
Return without credit note |
Return not recorded |
Raise the credit note |
Example: your bill book runs from 2001 to 2500. Your system skips 2481 to 2489. You find five unrecorded cash sales, three cancelled bills, and one duplicate. Now every number has a reason.
Fix each mistake the right way. Add missing sales with the correct date. Remove duplicate bills and keep a note. Make credit notes for returned goods. Ask your accountant how to fix GST on a wrong bill. Keep a record of every change to an old bill.
Reconcile payment receipts
Next, check that the money in your books matches the money you received. Each payment method has different fees and payment times.
Match these payments with your sales records:
- Cash: Compare cash sales with cash deposited.
- UPI: Compare UPI sales with bank credits.
- Cards: Compare card sales with settlements. A settlement is the payment the provider sends to your bank after collecting from the card.
- Bank transfers and cheques: Match each one with its invoice.
This matching is part of bank reconciliation. It means comparing your books with your bank statement and explaining every difference.
|
Difference |
Why it happens |
What to check |
|
Money not in bank yet |
Settlement delay |
Provider’s settlement report |
|
Bank credit lower than sales |
Fees deducted |
Fee line in the report |
|
Bank credit higher than sales |
Advance or older bill paid |
Customer name and reference |
|
Cash not deposited |
Deposited late |
Deposit slip and date |
Example: You record ₹1,00,000 in card sales, but the bank gets ₹98,200. The ₹1,800 difference is the fee charged by the provider. Record it as a bank charge. This keeps your books correct.
Record card fees under bank charges. These fees may include GST. Keep the provider’s monthly statement as proof.
Check the dates too. A sale made late on Saturday may reach your bank on Monday. Match the money by the date it reaches your bank. This helps you avoid mistakes. Mark the money as pending and tick it off when it arrives.
Money may take a few days to reach your bank, especially on bank holidays. If the money is still missing, contact the provider. Keep the date, amount and reference number ready.
Settlements can take a few days, especially around bank holidays. If one is still missing, raise it with the provider. Keep the date, amount and reference number ready.
Do not hide unexplained differences in a miscellaneous account. Keep a separate list and review it daily until it is empty.
Review purchases and supplier invoices
Many businesses buy heavily before Diwali. Goods come in many deliveries. Some arrive before the invoice does.
Use a three-way match. It means comparing three documents for each purchase:
- Purchase order: what you asked the supplier to send.
- Delivery record: what actually arrived, such as a goods receipt note or delivery challan.
- Supplier invoice: what the supplier is charging you.
If all three agree on item, quantity and price, the purchase details are consistent. If not, raise a query with the supplier.
Follow these steps:
- List all purchase orders from the festive period.
- Tick off those with a delivery record.
- Tick off those with a supplier invoice.
- Check quantities and rates against the order.
- Check the GST amount and the supplier’s GSTIN on each invoice. A GSTIN is the 15-character GST number of a registered business.
- Match each payment with its invoice.
Then keep two lists.
|
List |
What goes in it |
Why it matters |
|
Pending invoices |
Goods received, no invoice yet |
The cost may be missing from your books |
|
Disputed amounts |
Wrong rate, short supply, damaged goods |
Settle before paying in full |
For each problem, write the supplier’s name, invoice number, amount, reason and date you informed them. Also, write who will follow up. This helps you track each problem until it is fixed.
Example: You ordered 200 gift hampers at ₹500 each. But you received only 190. The bill still shows 200 hampers. Pay for 190 hampers or ask for a new bill. Keep a note of the 10 missing hampers until the supplier replies.
Also, look for goods on your shelf that are not in your system. They will show as extra stock later.
Conduct a physical stock count
A physical stock count means counting items by hand in your shop and godown (storeroom). This is the core of inventory reconciliation after Diwali.
Start where mistakes cost the most:
- High-value items, such as electronics, jewellery and premium gift packs.
- Fast-moving items, such as sweets, dry fruits, decor and lights.
- Items with many returns or exchanges.
Document your method. It makes the count believable to your accountant and auditor. Note these points:
- Start and end date and time.
- Place counted, such as shop floor or godown.
- Who counted and who checked.
- A cut-off rule, such as no stock moves while a shelf is being counted.
- Where damaged and return-pending stock is kept. Count it separately.
Use a simple count sheet:
|
Item code |
Item |
System qty |
Physical qty |
Difference |
Remarks |
|
G-101 |
Gift box, large |
500 |
480 |
-20 |
Investigate |
|
D-205 |
Diya set |
300 |
305 |
+5 |
Check purchase entry |
Ask a second person to recount big differences. This avoids counting slips.
Count shelf by shelf. Stick a tag on each counted shelf so nothing is counted twice or missed. Count open cartons and loose items too. Mark sealed cartons with their quantity. Count when the shop is closed or quiet, so sales do not change the numbers while you count. Also check the item codes on the shelf against the system.
The same item may sit under two codes. If you use inventory management software, print the stock report for the same date and time as your count. Then compare it line by line. Reports from different dates will never match.
Investigate stock discrepancies and returns
A gap between system stock and physical stock is a question, not a loss. Find the answer before you change any number.
|
Cause |
What it looks like |
Where to look |
|
Damage or breakage |
Physical stock lower |
Damage register |
|
Customer returns |
Shelf stock higher than system |
Credit notes, return slips |
|
Transfers between shops or godowns |
One place short, another extra |
Transfer slips, challans |
|
Unrecorded sales |
Physical stock lower |
Bill book, cash slips |
|
Unrecorded purchases |
Physical stock higher |
Delivery records |
|
Data-entry errors |
Wrong unit or item |
Entry date, item code |
Check units on items with big gaps. A box of 12 may be entered as 12 boxes.
Check the dates too. A sale made on the count day may not be in the system yet. Note the last bill number before the count. Use it to set the cut-off. Bills made after that belong to the next period. Ask staff what happened too. The person who handled the shelf may help you find the problem quickly.
Example: The system shows 500 gift boxes, but you count only 480. Twelve boxes were damaged during delivery, as evidenced by a damage note. Five boxes were sold for cash, but the bills were never entered. Three boxes are still missing. You have explained 17 of the 20 missing boxes. Keep the last three open until you find the reason. Do not remove them from your stock records yet.
Record every approved change with proof. A stock adjustment changes the system count to match the real count. Keep these details:
- Item, quantity, and value.
- Reasons, such as damage, return or error.
- Supporting document, such as a damage note, photo or credit note.
- Approver’s name and date.
Never adjust stock just to make numbers match. That hides the problem and it will return next year.
Record returned goods by type. Resalable returns go back to stock. Damaged returns are recorded separately until you decide what to do with them.
Review receivables and payables
Festive sales often include credit sales. Festive purchases often come with credit terms. A few weeks after Diwali, both kinds of dues fall due together. Tracking these balances helps businesses maintain sufficient cash flow.
Start with money customers owe you. This is called accounts receivable. List every customer with an unpaid balance. Sort by age. An ageing report groups unpaid bills by how long they have been pending, such as 0 to 30, 31 to 60 and above 60 days.
Then list the money you owe suppliers. This is called accounts payable. List every unpaid supplier bill with its due date.
Now check these points:
- Overdue customer balances: Who has passed the due date? Which balances are the largest?
- Upcoming supplier payments: What falls due in the next two to four weeks? Is there enough cash?
- Unresolved differences: Ask for a statement of account and compare it line by line.
- Unmatched payments: Is any advance or receipt sitting unallocated?
Give every line an owner and a date.
|
Party |
Type |
Amount (₹) |
Issue |
Owner |
Follow-up date |
|
Customer A |
Receivable |
45,000 |
20 days overdue |
Sales manager |
22 Nov |
|
Supplier B |
Payable |
80,000 |
Due next week |
Accounts executive |
25 Nov |
|
Supplier C |
Payable |
12,500 |
Short supply |
Purchase manager |
24 Nov |
Keep reminders polite and clear. Mention the invoice number, amount and due date. Plan supplier payments by due date to avoid late charges and maintain good supplier relationships.
Offer customers an easy way to pay. Share bank details, a UPI link or a QR code with the reminder. For large dues, call the customer. For repeat late payers, review the credit limit before the next order. Check if any supplier gives a discount for early payment. Take it when your cash allows.
Update financial reports and close pending tasks
After your records are corrected, your reports show what really happened.
|
Report |
What improves |
|
Sales report |
True festive sales, no missing or double bills |
|
Stock summary |
Real quantities and values for reordering |
|
Profit and loss |
Correct cost of goods sold and margins |
|
Cash and bank report |
Matches the bank, so your cash position is clear |
|
Receivables and payables reports |
Who owes you and whom you owe |
|
GST reports |
Match your bills, so fewer corrections later |
Good accounting software helps because sales, purchases, stock and bank entries sit in one place. When you correct one entry, related reports update too.
Close pending tasks with this list:
- Every festive invoice is recorded, cancelled with a reason, or explained.
- Every payment receipt is matched or listed as an open difference.
- Every supplier invoice is matched, pending or disputed.
- The stock count is documented and signed off.
- Every stock adjustment has a reason, proof and approval.
- Overdue dues have an owner and a follow-up date.
- A data backup is taken after the final corrections.
Keep a reconciliation log. It is a simple record of what you checked, found and did.
|
Date |
Area |
Difference |
Reason |
Action |
Done by |
Status |
|
20 Nov |
Card settlements |
₹1,800 |
Provider fee |
Booked as bank charge |
Accounts executive |
Closed |
|
21 Nov |
Gift box stock |
20 units |
Damage, unrecorded sales |
Adjusted |
Store in-charge |
3 units open |
The log shows your team what is open. It gives your accountant a clear trail. Next Diwali, it shows which areas caused trouble.
Review the reports with your accountant. Share the log, the count sheet and the list of adjustments. They can tell you if any entry needs a correction before the GST return is filed.
Wrapping up
Diwali sales are great, but they leave loose ends. Verify sales, match payments, check purchases, count stock and chase dues. Update your reports and keep a log. A few focused days now save weeks of confusion later. Clean records help you plan stock and cash. TallyPrime brings billing, inventory, accounts and GST reports into one place, so you spot gaps early. Explore TallyPrime and close your festive books with confidence.