Easy Cash Management Question
djswim
Member Posts: 277
So to bring in the initial bank account balance for a company, we plan on making a journal entry (one side G/L Cash Account, the other the Bank Account) equal to the Cash Account balance PLUS the sum of any outstanding items (checks/deposits/transfers). Then we'll make the associated ledger entries to get the outstanding items in one by one, bringing the Bank Account balance equal with the G/L Cash Account.
As the outstanding items clear the bank, we'll clear them on the Bank Rec. My question is this: What is best practice for clearing that initial entry (the one equal to cash account plus sum of outstanding items)?
Thanks in advance!
As the outstanding items clear the bank, we'll clear them on the Bank Rec. My question is this: What is best practice for clearing that initial entry (the one equal to cash account plus sum of outstanding items)?
Thanks in advance!
"OMG ALL MY DATA IS GONE"
"Show All..."
"Oh..."
"Show All..."
"Oh..."
0
Answers
-
I hate doing this but I'll give it one bump.
Do people just leave that initial entry in there indefinitely and ignore it?"OMG ALL MY DATA IS GONE"
"Show All..."
"Oh..."0 -
You have already reconcilled it, so it is simply an opening balance that carries on, you never close it off. It is a bit like trying to close off the closing balance to the last statement, you do not close it off, it is reconcilled. Of course I have to be careful as if for instance you are in the US the reconciliation process is very different to the UK, although that should not alter the principle of the opening balance!The art of teaching is clarity and the art of learning is to listen0
-
djswim wrote:So to bring in the initial bank account balance for a company, we plan on making a journal entry (one side G/L Cash Account, the other the Bank Account) equal to the Cash Account balance PLUS the sum of any outstanding items (checks/deposits/transfers). Then we'll make the associated ledger entries to get the outstanding items in one by one, bringing the Bank Account balance equal with the G/L Cash Account.
As the outstanding items clear the bank, we'll clear them on the Bank Rec. My question is this: What is best practice for clearing that initial entry (the one equal to cash account plus sum of outstanding items)?
Thanks in advance!
Yes, this is the best practice to load in beginning bank balance. You would clear it when doing your first bank reconciliation.
Hmm.. This is a great topic that should be blogged..
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
But to clear it don't you have to fudge on the statement information that you give it, or do you take care of it in it's own separate reconciliation?
You could theoretically leave it in there forever, but that's not very tidy in my opinion."OMG ALL MY DATA IS GONE"
"Show All..."
"Oh..."0 -
Yes, so if the client is going live 1/1/09, and you're loading in beginning balance as of 12/31/08. Then you would do the reconciliation on 12/31/08.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Ok, so just so I can mark this "Solved", the initial entry comes in by itself and gets it's own fake bank rec. to clear it, with a statement balance of the amount.
That sound like it?"OMG ALL MY DATA IS GONE"
"Show All..."
"Oh..."0 -
Yep, you got it. I wouldn't call it a fake bank rec. It's an initial bank rec that cleared all the previously cleared transactions.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 328 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