Checkbook balance and cash balance do not match

[Lee]

Does anyone know how to correct a checkbook account if the balance does not
match the cash account it is attached to? I believe this may have occurred
when we created the checkbook id after using the cash account.

[Victoria [MVP]]

Lee,

If you cash GL account has the correct amount and you need to change the
checkbook to match it, here are 2 options:

1. If you have not reconciled the checkbook yet (ever), you can fill in the
last reconciled balance on the checkbook maintenance screen. This option is
only available before you run the first reconciliation for a checkbook.
2. Enter a bank transaction of type increase adjustment or decrease
adjustment (depending on which way you need to adjust) and put the debit and
credit to the cash account - when posted this will result in a zero change
to the GL but will adjust the checkbook balance as needed.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Lee
Does anyone know how to correct a checkbook account if the balance does not
match the cash account it is attached to? I believe this may have occurred
when we created the checkbook id after using the cash account.

[Andy]

Victoria,

We are *trying* to convert our gl to GP. We have been posting journal
entries to our GL account, but they are not flowing through to the checkbook.
Is the increase/decrease amount the only thing that affects the checkbook?
How would you post multiple transactions to the checkbook in one entry?
Would you have to show the net increase/decrease as the amount? Can you post
to the checkbook with integration?

Any help would be greatly appreciated!

Thanks,
Andy

Post by Victoria [MVP]
Lee,
If you cash GL account has the correct amount and you need to change the
1. If you have not reconciled the checkbook yet (ever), you can fill in the
last reconciled balance on the checkbook maintenance screen. This option is
only available before you run the first reconciliation for a checkbook.
2. Enter a bank transaction of type increase adjustment or decrease
adjustment (depending on which way you need to adjust) and put the debit and
credit to the cash account - when posted this will result in a zero change
to the GL but will adjust the checkbook balance as needed.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Lee
Does anyone know how to correct a checkbook account if the balance does not
match the cash account it is attached to? I believe this may have occurred
when we created the checkbook id after using the cash account.

[Mark Polino [MVP] (DynamicAccounting.net)]

Andy,

With very exceptions, GP transactions flow downstream into the GL.
They don't flow out of the GL into other modules. So AP transactions
flow down to the GL. AP payments flow down to the checkbook and then
to the GL, etc.

It sounds like you've been making cash entries in the GL instead of to
the checkbook. You need to make cash entries to the checkbook either
directly or through another module like AP or AR that interfaces with
the Checkbook.

To your question, yes you can integrate bank transactions via
integration manager.

Mark

Post by Andy
Victoria,
We are *trying* to convert our gl to GP. We have been posting journal
entries to our GL account, but they are not flowing through to the checkbook.
Is the increase/decrease amount the only thing that affects the checkbook?
How would you post multiple transactions to the checkbook in one entry?
Would you have to show the net increase/decrease as the amount? Can you post
to the checkbook with integration?
Any help would be greatly appreciated!
Thanks,
Andy

Post by Victoria [MVP]
Lee,
If you cash GL account has the correct amount and you need to change the
1. If you have not reconciled the checkbook yet (ever), you can fill in the
last reconciled balance on the checkbook maintenance screen. This option is
only available before you run the first reconciliation for a checkbook.
2. Enter a bank transaction of type increase adjustment or decrease
adjustment (depending on which way you need to adjust) and put the debit and
credit to the cash account - when posted this will result in a zero change
to the GL but will adjust the checkbook balance as needed.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Lee
Does anyone know how to correct a checkbook account if the balance does not
match the cash account it is attached to? I believe this may have occurred
when we created the checkbook id after using the cash account.

[Andy]

Mark,

Thank you for the helpful response. Do you by any chance know why only the
amount entered as an increase/decrease goes to the checkbook? What is I want
to post several banking transactions at the same time; do I take the net of
them all? It doesn't make sense to me that the checkbook and g/l could
differ if they are both supposed to represent the same bank account. I've
never seen anything like this before, but most of my experience has been with
SAP and I've always just done my recs in excel.

Thanks again,
Andy

Post by Mark Polino [MVP] (DynamicAccounting.net)
Andy,
With very exceptions, GP transactions flow downstream into the GL.
They don't flow out of the GL into other modules. So AP transactions
flow down to the GL. AP payments flow down to the checkbook and then
to the GL, etc.
It sounds like you've been making cash entries in the GL instead of to
the checkbook. You need to make cash entries to the checkbook either
directly or through another module like AP or AR that interfaces with
the Checkbook.
To your question, yes you can integrate bank transactions via
integration manager.
Mark

Post by Andy
Victoria,
We are *trying* to convert our gl to GP. We have been posting journal
entries to our GL account, but they are not flowing through to the checkbook.
Is the increase/decrease amount the only thing that affects the checkbook?
How would you post multiple transactions to the checkbook in one entry?
Would you have to show the net increase/decrease as the amount? Can you post
to the checkbook with integration?
Any help would be greatly appreciated!
Thanks,
Andy

Post by Victoria [MVP]
Lee,
If you cash GL account has the correct amount and you need to change the
1. If you have not reconciled the checkbook yet (ever), you can fill in the
last reconciled balance on the checkbook maintenance screen. This option is
only available before you run the first reconciliation for a checkbook.
2. Enter a bank transaction of type increase adjustment or decrease
adjustment (depending on which way you need to adjust) and put the debit and
credit to the cash account - when posted this will result in a zero change
to the GL but will adjust the checkbook balance as needed.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Post by Lee
Does anyone know how to correct a checkbook account if the balance does not
match the cash account it is attached to? I believe this may have occurred
when we created the checkbook id after using the cash account.