Notifications
Announcements
No record found.
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
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?
Business requirement - we wanted to use the same checkbook but put a description in the EFT file
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.
ok I will try putting the description in the user defined filed and bring that in when the EFT file is created. Thanks
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 thanks-is there a way to bring all the transaction from one check book to another?
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
Thank you I appreciate your help
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
