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.

Reply via email to