You’re offline. This is a read only version of the page.
I have 2 check book id and one bank statement-how can I reconcile the two checkbook id to one bank statement.
*This post is locked for comments
Thank you I appreciate your help
Hi Sandy,
Not really anything built-in to do this. Victoria's solution is probably the best. The only way I can think of is to create a 'combined' checkbook and then import all of the transactions from both checkbooks as bank transactions into the third. I had a client several years back where we had to do this every month in order to achieve some reporting magic. Once you get it set up, Integration Manager handles this type of thing easily. The source for the integration is the GP tables, so there's no data manipulations necessary (in Excel, etc.). To avoid the whole posting to GL concern, we created a suspense account, called that the combined cash account and then posted both sides of the entries to that suspense account. It was pretty sweet in that we could use the bank rec module. We were using the Electronic Reconcile feature. That's the only time I came across having to combine checkbooks on a regular basis.
Kind regards,
Leslie
ok thanks-is there a way to bring all the transaction from one check book to another?
I see this requirement crop up periodically for various reasons. Unfortunately, if you must have 2 separate checkbook IDs for the same bank account, it will be pretty impossible to use the Bank Rec module functionality to reconcile to the bank statement. You will have to reconcile manually in Excel.
ok I will try putting the description in the user defined filed and bring that in when the EFT file is created. Thanks
I don't know the whole background but I almost want to suggest seeing if there is a way to get that description in to the EFT file other than having to split the checkbooks up (not sure how much headache it would be to go back to one, though). Were either of the user-defined fields on the Checkbook Maintenance window not an option? Or even one of the fields on the Checkbook EFT Bank Maintenance window? Those should all be available to bring in to the EFT file.
Unless someone has a better idea, it seems like having them split out is just causing additional work for you or whomever is doing the reconciliation.
Business requirement - we wanted to use the same checkbook but put a description in the EFT file
If there is no breakout on the bank statement the only thing I could think of would be to manually calculate the ending balance for each Checkbook ID. Maybe you can export the statement to Excel and break out the transactions there.
Out of curiosity, what was the reasoning behind having two separate Checkbook IDs for the same account?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (