B. Sales Verification & Sales Taxes Verification
B.
1. What is Sales Verification & Sales Taxes Verification.Verification?
----------
Firstly, salesSales verification meaningmeans that,checking that the total value of issued bills sales (after discount valuediscounts) is ourproperly income.recorded so, thatas income valuein shouldaccounts.
At matchedthe same time, the sales tax register’s net tax must also match with ourthe accounttax totalrecorded income.in accounts.
Since every issued bill is already recorded in the sales tax register'sregister, netwe taxcan alsotrust shouldthe matched with account tax.register as we know, the issuedbase. bill'sMatching recorded in sales tax register so, sales tax register sales is accurate. so matching account sales & taxes with the sales tax register isensures verifiedthat both revenue and tax weare cancorrect.
⚠️ (doImportant: Do not forgetstart tothis reviewstep until the first steps before(entries processingclearance, thisuser step)rights verification, inactive setup check) are completed.
2. Sales Data Flow & Cases
To begin verification:
-
Load the Sales Tax Register in
account.Accounts.make -
toSelect
choosethe correct fiscal yearwhich datayou want to tally.as -
know, sales tax register sales, booked in account byRemember, only
Sales,Sales and Credit Notebookvoucherstype(bookedvoucherfromwhichSalesonlyPosting,canCredit Note, or A/C Bill entry) should bepostedpartfrom sales posting, credit note and ac bill entry. generally we thinkof the salesregisterregister.sales
surewe&account👉
trialManyincome'sassumenetthat the Sales Register income will always match with Trial Balance (Income Ledger) orprofitP&L&NetlossIncome.reportsButnetmismatchesincome matched. but, not alwayshappen becausewe do entryofnonnon-salesjournalvouchersvoucherorand credit note voucher which only value already in sales register, these non sjv & crn entries show high income inwrong ledgercomparingpostings.toThat’s
sales register. it means we need a data only sales voucher and credit note voucher. we can' figure out or verify each entry wise sales so, we have report in account named 'Ledger Reconcile Report' from here can figure out data flow this entire sales verification processwhy we usethisthereport.Ledger Reconcile -
Here,Reporti;minshowingAccounts. This report helps track the flow of salesregisterdatamismatchandcases
is the key tool for sales verification.
3. Common Mismatch Cases
-
Case 1: Non-SJV & CRN
voucherVoucherentriesEntries
Incometoledgerincomesometimesledger,includesthisnon-SalescontributeJournaltoVouchersmismatch(SJV)salesorregisterextradataCreditandNoteaccountvouchers.
Thesesales.dobecausenotthis record sales which isn't reflectedappear in the sales taxregister.
register, causing mismatches. -
Case 2: Remaining
postingPostings
If-Salessometimesor Credit Notes are not posted, they will not appear in accounts, while they already exist in the salesisn'tregister.recorded -
of remaining posting (sales, credit note). to make sure to clear remaining posting.Case 3: Wrong Ledger Posting
Salesbooking in non-income ledger : salesshould onlyshouldbe recorded inincomeIncomenotLedgers.
Sometimes, by mistake, sales are posted underassets,Assets,expenseExpenses,liabitliy.or Liabilities,sometimeswhichmistakenlycreatessalesmismatches.booked -
income account category this also affect sales mismatch.Case 4:
RoundRound-OffValue : roundIssues
Round-offfigureshould be very small (not more than ±0.5 normally).
If round-off values are unexpectedly large, it may be due to technical errors or bugs. Always verify round-off figures against transaction size. -
Case 5: VAT Bill & Credit Note Issues
When issuing VAT bills for IRD approval and then adjusting them with credit notes:-
Sometimes only the
figureCreditwhich shouldn't be greater then 0.5. but, sometimes technical issue or BUG sales value may booked inside of round off. so, make sure to verify round off figure. if thatNote isvery high as that client transaction. small transaction has small value of round, big then little big but, not huge.Case 5: we issue vat bill for ird approval. this also sales. after we issue credit note for adjust vat, sales and collection. sometimes we don't post sales but, post credit note or salesposted but notcreditthenoteSales.or -
Or Sales is posted but not the Credit Note.
-
Or a sample bill is generated in
lastone fiscalyearyear,but,but the credit noteissuedis posted in the nextfiscalyear.
Allyear.these cause mismatches — somake sure tochecksample bill's accountpostingstatus.
status carefully.
-
-
Case 6: [Reserved for additional cases based on audit findings]
becausenon
4. Data Tally (Register vs Ledger)
Steps for reconciliation:
-
Load Sales Tax Register.
-
Load Ledger Reconcile Report in Accounts.
-
Filter by Direct Income, Indirect Income.
-
Voucher type: Sales & Credit Note.
-
-
Compare both reports.
-
If mismatched, review the above cases.
-
If sales values are in non-income ledgers, re-check voucher type (Sales, Credit Note) and where they were posted.
-
DataForTallyclient explanation:-
Use the Ledger Reconcile Report to show the exact voucher flow.
-
Demonstrate: “This voucher created this entry, and this is why mismatch occurred.”
✅ With this process, you can confidently verify whether reported sales and taxes are accurate and fully matched between the Sales Tax Register and Accounts Ledger.
chooseDocumentedmainByhead-:Sundaryour income heading, voucher type : sales, credit note.Mishra.-