Reconciliation

370 views 4 replies

What best way and format to reconsile two statements like vendor reco

Replies (4)
After recording transactions at one end then just point out entries which are not matching and do addition, subtraction logically
Any format to presrent reconsilation.
TAKE A PRINT OUT OR SOFT COPY (EXCEL/WORD) OF BOTH LEDGER AND MARK SAME SR. NUMBER ON SAME MATCHED ENTRY, AUTOMATICLY UNMATCH ENTRY STAY BALANCE (UNMARK)

Keep it simple, maybe use this format in excel :-

Date Document no. External document no. Debit  Credit
         
         

Document no. is the number generated by ur ERP, for e.g payment voucher will be debited and Invoice will be credited.

External document no. is the invoice or bill no. from vendor. 

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register