Re: [GNC] Entry of unknown transaction
This might be a timing case. There are different ways to handle it, some just ignore it, but one method is to employ an 'undeposited funds' account for checks you receive into a book that have yet to be deposited and cleared as an intermediary account. This allows you to show a receipt date, and then a deposited or cashed date that reflect real world events. Otherwise, do they show up in an income or expense account? If so, show splits or turn on View > Transaction Journal mode to see the other side of the transaction and fix it if incorrect. If you can't find them at all (by doing a Find) then double check that your expected registers don't have a Filtered view turned on. And no, nothing should be in the 'Imbalance' or 'Orphan' accounts. If there are transactions in them, you should investigate and find out what those accounts should be and fix them. (nothing wrong with a Expenses:Miscellaneous account for very infrequent transactions, I have a few of those) Regards, Adrien On 2/6/23 12:16 AM, Jeff wrote: Easiest example that I can remember off the top of my head is, my wife recently wrote a check from her business account (her weeks wages) and deposited it directly into our personal account. The OFX import, and statement, from our bank show it but there is no matching transaction in the business account. Our statement has an image of the check plain as day but there is no match, period, in her business account statement(s). And what really has me bumfuzzled is both sets of books are reconciled per their respective statements. And it's not just one transaction involved, there are multiples. That check did not bounce, it just seemingly like magic appeared in our account out of thin air. Magic money. For now I have the check recorded as a deposit to our account and withdrawal from Imbalance-USD. Just wanted to get your input on if that is the best way to handle transactions like that. Her PayPal dealings are even worse but; that is for a different thread. ___ 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.
Re: [GNC] Entry of unknown transaction
On Mon, 6 Feb 2023 00:16:01 -0600 Jeff wrote: > Easiest example that I can remember off the top of my head is, my > wife recently wrote a check from her business account (her weeks > wages) and deposited it directly into our personal account. The OFX > import, and statement, from our bank show it but there is no matching > transaction in the business account. Our statement has an image of > the check plain as day but there is no match, period, in her business > account statement(s). And what really has me bumfuzzled is both sets > of books are reconciled per their respective statements. And it's > not just one transaction involved, there are multiples. That check > did not bounce, it just seemingly like magic appeared in our account > out of thin air. Magic money. > > > For now I have the check recorded as a deposit to our account and > withdrawal from Imbalance-USD. Just wanted to get your input on if > that is the best way to handle transactions like that. Thanks for that, now I have understood. You are depending on the bank's version of your account(s) to maintain your view of your accounts. Your view is of course far more up to date, because you know that the money was transferred from X to Y. These are personal choices on how you maintain your accounts, nothing is right nor wrong. I had initially thought that you had made an entry in Gnucash and that entry had lost one side of the transaction. Cheques (checks to you) have multiple delays in processing and data entry in any bank's procedures. Personally my wages go by direct transfer from business to personal, on a regular schedule booked online with my bank. Liz ___ 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.
Re: [GNC] Entry of unknown transaction
David, A possible explanation is a difference in the timing of recording of the check by yourself and the bank if it is close to the banks closing date for the statement. It will depend upon the time taken for the bank to clear the check and record the deposit. These days with electronic clearance it should be pretty quick but there are always exceptions. That might explain it not being on a statement. It should be in the OFX data though once it has been cleared. David Cousens On Mon, 2023-02-06 at 00:16 -0600, Jeff wrote: > On 2/4/23 11:46 AM, David Carlson wrote: > > I have occasionally found a stray deposit receipt near an ATM when I > > was withdrawing cash. If I carelessly pocketed it with my receipt, I > > might get a surprise later. The stray would have a different account > > number on it. Could this be what happened to you? > > > > On Sat, Feb 4, 2023 at 8:32 AM Michael Hendry > > wrote: > > > > On 4 Feb 2023, at 11:58, Jeff wrote: > > > > > > > > I have discovered several transactions that show up in one > > account but do not show up in any other existing account. > > Regardless of what the bank image shows of where the check was > > deposited. > > > > > > I.E. I have a deposit slip that shows it went to our checking > > account but never showed up there (OFX or printed mailed > > statement). I can not reconcile it so how do handle it? > > > > > > In other words, I have half of a double entry transaction. More > > than one, unfortunately. > > > > > > -- > > > --JEffrey Black M.B.A. > > > > Not entirely sure what you mean, Jeffrey. > > > > Are the transactions you refer to recorded in GNUCash as money > > paid into your account but without a recorded source account? This > > should have a corresponding entry in the Imbalance account, > > automatically created when you put in an unbalanced transaction. > > > > Did you receive a check which you deposited in your checking > > account and for which your received a receipt from the bank in the > > form of a date-stamp on the deposit slip, but for which there is > > no record in the bank statement (paper or electronic)? > > > > If yes, then you need to take that up with the bank - was the > > check bounced? > > > > When you’re reconciling, you’re matching up the bank’s view of the > > world with your own, and can only mark as reconciled the > > transactions which appear in both. > > > > Michael > > > > > > ___ > > 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. > > > > > > > > -- > > David Carlson > > > Easiest example that I can remember off the top of my head is, my wife > recently wrote a check from her business account (her weeks wages) and > deposited it directly into our personal account. The OFX import, and > statement, from our bank show it but there is no matching transaction in > the business account. Our statement has an image of the check plain as > day but there is no match, period, in her business account > statement(s). And what really has me bumfuzzled is both sets of books > are reconciled per their respective statements. And it's not just one > transaction involved, there are multiples. That check did not bounce, > it just seemingly like magic appeared in our account out of thin air. > Magic money. > > > For now I have the check recorded as a deposit to our account and > withdrawal from Imbalance-USD. Just wanted to get your input on if that > is the best way to handle transactions like that. > > Her PayPal dealings are even worse but; that is for a different thread. > ___ 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.
Re: [GNC] Entry of unknown transaction
On 2/4/23 11:46 AM, David Carlson wrote: I have occasionally found a stray deposit receipt near an ATM when I was withdrawing cash. If I carelessly pocketed it with my receipt, I might get a surprise later. The stray would have a different account number on it. Could this be what happened to you? On Sat, Feb 4, 2023 at 8:32 AM Michael Hendry wrote: On 4 Feb 2023, at 11:58, Jeff wrote: > > I have discovered several transactions that show up in one account but do not show up in any other existing account. Regardless of what the bank image shows of where the check was deposited. > > I.E. I have a deposit slip that shows it went to our checking account but never showed up there (OFX or printed mailed statement). I can not reconcile it so how do handle it? > > In other words, I have half of a double entry transaction. More than one, unfortunately. > > -- > --JEffrey Black M.B.A. Not entirely sure what you mean, Jeffrey. Are the transactions you refer to recorded in GNUCash as money paid into your account but without a recorded source account? This should have a corresponding entry in the Imbalance account, automatically created when you put in an unbalanced transaction. Did you receive a check which you deposited in your checking account and for which your received a receipt from the bank in the form of a date-stamp on the deposit slip, but for which there is no record in the bank statement (paper or electronic)? If yes, then you need to take that up with the bank - was the check bounced? When you’re reconciling, you’re matching up the bank’s view of the world with your own, and can only mark as reconciled the transactions which appear in both. Michael ___ 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. -- David Carlson Easiest example that I can remember off the top of my head is, my wife recently wrote a check from her business account (her weeks wages) and deposited it directly into our personal account. The OFX import, and statement, from our bank show it but there is no matching transaction in the business account. Our statement has an image of the check plain as day but there is no match, period, in her business account statement(s). And what really has me bumfuzzled is both sets of books are reconciled per their respective statements. And it's not just one transaction involved, there are multiples. That check did not bounce, it just seemingly like magic appeared in our account out of thin air. Magic money. For now I have the check recorded as a deposit to our account and withdrawal from Imbalance-USD. Just wanted to get your input on if that is the best way to handle transactions like that. Her PayPal dealings are even worse but; that is for a different thread. -- --JEffrey Black M.B.A. ___ 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.
Re: [GNC] Entry of unknown transaction
I have occasionally found a stray deposit receipt near an ATM when I was withdrawing cash. If I carelessly pocketed it with my receipt, I might get a surprise later. The stray would have a different account number on it. Could this be what happened to you? On Sat, Feb 4, 2023 at 8:32 AM Michael Hendry wrote: > On 4 Feb 2023, at 11:58, Jeff wrote: > > > > > I have discovered several transactions that show up in one account but > do not show up in any other existing account. Regardless of what the bank > image shows of where the check was deposited. > > > > I.E. I have a deposit slip that shows it went to our checking account > but never showed up there (OFX or printed mailed statement). I can not > reconcile it so how do handle it? > > > > In other words, I have half of a double entry transaction. More than > one, unfortunately. > > > > -- > > --JEffrey Black M.B.A. > > Not entirely sure what you mean, Jeffrey. > > Are the transactions you refer to recorded in GNUCash as money paid into > your account but without a recorded source account? This should have a > corresponding entry in the Imbalance account, automatically created when > you put in an unbalanced transaction. > > Did you receive a check which you deposited in your checking account and > for which your received a receipt from the bank in the form of a date-stamp > on the deposit slip, but for which there is no record in the bank statement > (paper or electronic)? > > If yes, then you need to take that up with the bank - was the check > bounced? > > When you’re reconciling, you’re matching up the bank’s view of the world > with your own, and can only mark as reconciled the transactions which > appear in both. > > Michael > > > ___ > 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. > -- David Carlson ___ 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.
Re: [GNC] Entry of unknown transaction
On 4 Feb 2023, at 11:58, Jeff wrote: > > I have discovered several transactions that show up in one account but do not > show up in any other existing account. Regardless of what the bank image > shows of where the check was deposited. > > I.E. I have a deposit slip that shows it went to our checking account but > never showed up there (OFX or printed mailed statement). I can not > reconcile it so how do handle it? > > In other words, I have half of a double entry transaction. More than one, > unfortunately. > > -- > --JEffrey Black M.B.A. Not entirely sure what you mean, Jeffrey. Are the transactions you refer to recorded in GNUCash as money paid into your account but without a recorded source account? This should have a corresponding entry in the Imbalance account, automatically created when you put in an unbalanced transaction. Did you receive a check which you deposited in your checking account and for which your received a receipt from the bank in the form of a date-stamp on the deposit slip, but for which there is no record in the bank statement (paper or electronic)? If yes, then you need to take that up with the bank - was the check bounced? When you’re reconciling, you’re matching up the bank’s view of the world with your own, and can only mark as reconciled the transactions which appear in both. Michael ___ 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.
[GNC] Entry of unknown transaction
I have discovered several transactions that show up in one account but do not show up in any other existing account. Regardless of what the bank image shows of where the check was deposited. I.E. I have a deposit slip that shows it went to our checking account but never showed up there (OFX or printed mailed statement). I can not reconcile it so how do handle it? In other words, I have half of a double entry transaction. More than one, unfortunately. -- --JEffrey Black M.B.A. ___ 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.