Bank Reconciliation Made Slowly [Csi]

Agustus 11, 2018   CSI   Comment  

First depository fiscal establishment annotation downwardly House depository fiscal establishment I'd together with Bank key

FCHI

• House bank- click searcher
• Remove filter 500 together with list
• Searcher - primal inwards depository fiscal establishment name
• (Note downwardly for each bank)

View ruby ink exceptional (unadjusted item)

FAGLL03

• GL (Bank Drawings / Bank remittance  for the state)
• Posting appointment (Select From together with To equally Last month)
• Custom selections : Year & PC
• F8(Copy it inwards Excel)

Scroll Entry past times schedule PA

FF67

• (Varient - DOPI , Type - 4)
• Bank primal (Available from FCHI)
• Bank ac no (Available on PM Cheque)
• Currency : INR
• Statement no - (Scroll number)
• Statement appointment - electrical flow date
• Bank posting exclusively - Tick
• Press <enter> iii times

Trans : DP01 (For Remittance)

             DP02 (For Drawings)

Profit center 

Bank Ref  : Chq No. For drawings

                   (Assignment inwards FAGLL03)

                   : Doc. No. For Remittance

                   (Doc. No  inwards FAGLL03)

Amount :   Amt 

(Prefix minus symbol for drawings)

 Doc. appointment : PO accounting date

Value appointment : scroll date

( Enter all row entries similar this )

click GOTO - Change controls

(Press larn inwards equally many times equally the publish of row entries)

Finally, OB/CB covert volition endure displayed.

Opening residual :  0

Closing balance   : Total  amt.  

(Prefix minus sign earlier the Total

Amt. inwards illustration of Drawings)

Click Tick

Click Tick

(Entered Amt &  Bank Amt are tallied)

Save

Save

(A tabular array of entries inwards Yellow colour volition endure displayed)

Verify the reconciliation  past times APM accounts

FEBAN

DOPI

House depository fiscal establishment : (Available from FCHI)

Account I'd : click searcher

              R00001 (For Remittance)

              D00001 (For Drawings)

• Execute
• Click arrow inwards front end of House bank
• (The scroll entries volition endure listed down)
• Select the ruby entry
• Post

(Drawings volition endure adjusted therefore together with there)

For Remittance :

   Click document

   Enter Dr. no inwards From & To

   Post

(Do these for each entry)

(The entries inwards FEBAN covert volition endure Green.)

• Check inwards FAGLL03 together with verify the entries are Green now. Note that Clearing document column are filled alongside document numbers. Export to Excel.
• Print

View the reconciliation report

Zfi_Recon

(Dont worry .This won't work..!!)

So FAGLL03 Report is enough.

Note i : The  reconciled sum volition seem inwards the DAC of that net income pump on both Receipts together with Payments nether Bank reconcile GL for drawings together with Remittance.

Note two : The cheques from BNPL customers received equally monthly nib volition bring to endure adjusted similar this inwards Bank reconciliation procedure therefore equally to become accounted  in  the respective customer's account