Arthur:
On 2025-01-18 13:06, arthur brogard via gnucash-user wrote:
i just keep personal books for the family.
my update and reconcile procedure works but is a bit tedious. I can't think of
any better way and I doubt there is one but i thought it might be good to ask.
At sort of almost random times I decide to update the books. So I download
from CBA transactions from the bank accounts.
then I put them in a spreadsheet. in date order.
then I inspect and compare with a transaction report from gnu cash - one for
each account - and identify transactions not yet in gnu cash.
delete all but those from the spreadsheet.
sort on description.
attach a fourth column for target account.
import to gnu cash.
that's the update
balances should agree. that's the reconcile.
all that downloading, spreadsheeting, sorting blah, blah..... any better way
or that's just it?
Are you familiar with the Reconciliation feature of GnuCash?
It is described in sections 2.9.4. Reconciliation and 5.4. Reconciling
Your Accounts of the GnuCash Tutorial and Guide
<https://gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide>, as well as
sections 4.5. Reconcile Window and 5.8. Reconciling an Account to a
Statement of the GnuCash Manual
<https://gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=help>.
I won't repeat all of that here.
I collect receipts or emails for all transactions. Every week or so, I
go through them and enter all transactions. When the statement arrives,
it is usually in the form of a PDF file from my bank or credit card
company. I hope the statement in one window on my computer. I open
GnuCash, and the tab for that account, in another window. I push the
Reconcile button to start the process, and confirm that starting and
ending balances for the statement. The Reconcile Window appears. The
Reconcile Window has an entry for each unreconciled transaction in that
account. Next to each entry is an unchecked checkbox.
I hold a pencil or pointer next to each line of the statement, in the
one window, in turn. For each line of the statement, I find the
corresponding transaction in the Reconcile Window. I check the checkbox.
Sometimes I need to add or correct a transaction. For that, I go to the
account's register window, and make the change. The result appears
immediately in the Reconcile Window. Then I check the checkbox, and move
my pointer to the next line of the statement.
When I have gone through the statement, the Reconcile Window should have
an Difference value of zero in the bottom-right corner. I click the
Finish button. The Reconcile Window disappears. I close the window with
the statement PDF.
From your description of downloading transactions, putting them in a
spreadsheet, and deleting from the spreadsheet, it sounds like you are
reproducing in a less convenient way what the Reconcile feature already
gives you. Or maybe you are importing transactions — but that is not
reconciliation, that is data entry.
Does this help? Best regards,
—Jim DeLaHunt
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.