Re: [GNC] grouping deposited items

[Michael or Penny Novack]

On 3/3/2020 10:17 AM, Ian D Henry wrote:

I may have used the wrong search terms, but I can't find out if Gnucash has
a way of grouping deposited items so they can be matched with the deposit
amount on the bank statement.

Ian

Model the deposit ticket. This was a touch more obvious for me since 
very low volume meant usually several items to deposit before making a 
trip to the bank. But you can do this even if depositing daily.


Create an account, undeposited cash << the money is technically yours 
when the negotiable paper is received, not when you get around to 
depositing it >> As items for deposit come in, enter them here. You can 
think of this as the list of items on your deposit ticket. When you make 
the deposit, you debit the bank account and credit undeposited cash for 
the balance << no going back to zero; no undeposited items >>


When you get your bank statement, match deposits to the deposits in 
undeposited cash, and the transaction above this (up to the previous 
deposit) will be the individual items on that deposit.



Michael D Novack


--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] grouping deposited items

[Adrien Monteleone]

If your statement shows you total deposits and total withdrawals and you want 
to see if those two match, then the proper procedure is called ‘reconciliation’ 
and the documentation should cover this in some detail.

The basics are this:

1. Click the Reconcile button while viewing the account in question.
2. In the pop-up, set the statement date and the ending balance from the 
statement. (take not of opening balance, it should agree with the statement)
3. Check off each item in the deposit and the withdrawal columns that match 
individual transactions on your statement.
4. As you check items off, notice they are totaled under each column (what I 
think you are looking for)
5. When all items that match your statement have been checked off, the 
‘Difference’ amount in the bottom right should be zero, which means you’ve 
successfully reconciled. You can then click the Finish button on the toolbar.

If the Difference is not zero, you either missed a transaction to check off, or 
there are one or more transactions missing that need to be entered and then 
checked off, or, your starting balance was off because of a previously 
unfinished reconciliation. (note that editing a transaction after 
reconciliation will un-reconcile it. When doing such an edit, simply go through 
reconciliation again, check the edited transaction(s) and click Finish)

It is probably best to start reconciliation from the oldest date in your 
GnuCash books and work forward in time, statement by statement till you are up 
to date.

Regards,
Adrien

> On Mar 3, 2020 w10d63, at 9:17 AM, Ian D Henry  wrote:
> 
> I may have used the wrong search terms, but I can't find out if Gnucash has
> a way of grouping deposited items so they can be matched with the deposit
> amount on the bank statement.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.