Pos3/5/FNB: Why is the amount in Ledger Sales Account not the same as POS Posting payment

From AutoCount Resource Center
Revision as of 09:08, 4 February 2022 by PeterT (talk | contribs) (Created page with "<u><b>Question :</b></u> Why is my POS Posting total payment amount not the same as total sales amount in ledger report or profit and loss statement. File:000305-a.png File:000305-b.png <u><b>Possible Reason :</b></u> User did not include other sales related account codes in P&L or Ledger report such as discount and rounding adjustment. <u><b>Solution :</b></u> 1. Go to <span style='color:red'>Tools</span> > <span style='color:red'>Options</span> > <span...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Question :

Why is my POS Posting total payment amount not the same as total sales amount in ledger report or profit and loss statement.


Possible Reason :

User did not include other sales related account codes in P&L or Ledger report such as discount and rounding adjustment.


Solution :

1. Go to Tools > Options > G/L > Default Accounts > take note of account no. under Sale Discount Account.


2. Go to Stock > Stock Location Maintenance > select correct outlet > Edit > POS Posting Setting tab > take note of account no. under 5 Cents Rounding Adjustment Account No.


3. Go back to G/L > Ledger Report > Filter Options (select all related accounts, my sample is 500-1000, 520-0000 & 916-0000) > Inquiry

Sales Account (Home CR) – Discount Account (Home DR) – Rounding (Home DR – Home CR)= POS Posting Amount

500-1000 – 520-0000 – 916-0000 = POS Posting Amount

105874.41 – 447.63 – (0.40 - 0.32) = 105426.70


By: CK 20211229, Jacky 20220121, P220127 [000305]


Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations