Bank reconciliation
David Goodenough
david.goodenough at linkchoose.co.uk
Thu Nov 9 09:54:06 EST 2017
I imported transactions from my bank using "import ofx" which has
populated an account called "Imbalance-GBP" with various transactions.
One of the transactions represents paying in three cheques we had
received as payments for ads from three different customers which the
bank lumped together as one transaction.
>From googling I had come to the conclusion that I should set up a temporary holding
account (Account type: Asset), have that transaction pay into said account and then make
three different transactions to Assets:Checking Account and use them to pay the invoices.
However, when I (using the right click menu option while viewing all transactions in said
holding account) assigned these
transactions as payments for the invoices the transaction was moved to
Accounts Receivable automatically and moving it back (by editing the
other end of the transaction in Assets:Checking Account) causes the
invoices to become unpaid.
Clearly I am doing something wrong, quite possibly by not even using the
right solution to begin with and I don't think banging my head against
the problem/google any more will be productive, what should I do?
In short, what is the proper way to handle the case where a single paying-in transaction
needs to be reconciled against several invoices for multiple customers?
We try to encourage people to pay electronically, then none of this happens, and in future
if we can not find a solution to this we will ensure that cheques are paid in individually, but
we need to handle these historic transactions.
David
More information about the gnucash-user
mailing list