Downloading Cleared Transactions - Makes it Hard to Balance My Budget
Is there a way to download from my bank and NOT have everything automatically cleared? It is super hard to find missing transactions and/or duplicates (that I have posted ahead) when everything automatically clears. I would rather clear it as I go through my statement and make sure my accounting is synced with my bank's. Any helpful tools?
-
Hit the Select All button then Unclear.
-
Hi Navy Blue Mare !
Transactions that import from your bank will automatically be marked as cleared - there isn't a way to turn that function off. You can manually unclear the transactions, like dakinemaui mentioned, or manually enter them/use Scheduled Transactions so they aren't automatically cleared.
-
Faness the scheduled are not the issue it is the bits and pieces, especially as with Covid I do not carry cash anymore. In Europe and UK, no one wants to handle cash.
-
Navy Blue Mare that’s funny because I know in Germany at least cash is king. Wonder if that has changed. They are very privacy aware.
-
Navy Blue Mare I understand not being able to enter every single transaction. Would it help if you uncleared the transactions by date? For instance, if you uncleared transactions between the 1st and 5th, then cleared them as you go through your statement?
-
MXMOM We've had a few places here who don't prefer cash because of germs, but also want coins because of the shortage. It's an odd point in time for cash handling.
-
-
that's what I was afraid of:(
-
Navy Blue Mare are you not manually entering transactions as they occur?
-
MXMOM i do but i miss things and then the clearing complicates the duplications.
-
Navy Blue Mare hmmm. The imported ones should automatically match to the entered ones with a little “link” icon. Which by the way I get way too much pleasure from. I find that 90 to 95 percent Of them match so those are just a quick click to accept. They shouldn’t be duplicating. Where there is a difference in the amount (19.75 vs $19.57 for example) you can see this in the register. You click each one and select match and the incorrect one is updated with the amount from the import and they get a link icon. Then accept. Only things that should be left are the ones that were not entered for some reason. These are the ones that need a bit of investigation although most of the time I just know they are ok due to the store.
not sure why you are getting duplicates. Is this something new? -
MXMOM hi. Not sure if you are still having this problem but in case you are and in case you don’t know what I am talking about I did screenshots of my transactions import today. If this is not useful or doesn’t address your issue I apologize in advance
image 1 - 16 transactions imported.
image 2 - once I click on the import banner the imported transactions that match manually entered transactions have the link icon (very satisfying) I select all the matched transactions and click approve (or accept)image 3 - three new unrecorded transactions to deal with
image 4 - account screen the unmatched/unrecorded transactions have a coloured bar to the left the one transaction has a yellow bar because not only is it not recorded but YNAB doesn’t know what the category is . for the other 2 it assumed the category was the same as previous transactions. For the peacock lumber I KNOW I entered that but I accidentally entered it in my chequing account so I went to the chequing account and moved that transaction to the credit card and it matched up with the imported transaction. The other two were not entered (oops) but I know they are legit so I accept. It also could have been that the transaction was entered but the amount was wrong. If that was the case I could select the imported one and the entered one and select match. The transaction amount would be updated and a link icon will appear for me to click accept.
-
-
Navy Blue Mare said:
I would rather clear it as I go through my statementSee above for how to do that, but I would question why not reconcile to the web register as it's more up to date?
-
When you say "that I have posted ahead" do you mean that you are clearing transactions manually when they post, before they import?
If you use Direct Import, you should never clear transactions yourself. They should be marked as cleared automatically when they match with an uncleared transaction you entered.
If you don't clear transactions yourself, you shouldn't have any issues with duplicates.
