Bank Reconciliation

murthy
Member Posts: 11
Hi all,
I'm having difficulty with Bank Reconciliation.
- I have uploaded the closing balance as on Mar 31' 2007 and posted transactions for the month of Apr'2007.
- While doing bank reconciliation there are many items for the prior months that have hit the bank for April and there are some which are still open items for Mar'07 and before. How do i treat these items?
- Should i input the "Balance Last Statement" value?
Please let me know if anyone has an answer
Thanks
Venkat
I'm having difficulty with Bank Reconciliation.
- I have uploaded the closing balance as on Mar 31' 2007 and posted transactions for the month of Apr'2007.
- While doing bank reconciliation there are many items for the prior months that have hit the bank for April and there are some which are still open items for Mar'07 and before. How do i treat these items?
- Should i input the "Balance Last Statement" value?
Please let me know if anyone has an answer
Thanks
Venkat
0
Comments
-
The unreconciled open bank entries should have been entered as opening balance i.e the opening balance should have been
Balance as per bank statement + open (unreconciled entries) = closing balance.CA Sandeep Singla
http://ssdynamics.co.in0 -
You should be able to enter any open transactions by creating an entry that has one side as a "bank entry' and the the other as a journal entry to the bank account.
The net effect (from a general ledger point of view) will be zero as the bank entry and the g/l entry create equal offsetting general ledger entries.
However, this will allow these items to show up as bank transactions, which is what the bank reconciliation program is looking for.
Hope this helps.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions