Bank Reconciliation: I have a transaction that is ...
# accountingm
MaryPeace
12/04/2019, 4:02 PMBank Reconciliation: I have a transaction that is in NS, it shows as having cleared in our bank, I've imported transactions for the month, and again imported the dates relevant to the specific transactions. It is NOT showing up on the bank side of my rec. I've searched for the amount in matched transactions, and reviewed all the dates for the week surrounding the NS date.
Does anyone know of any way, short of un-matching everything, that I can find out what happened to the imported transaction?
n
Nicolas Bean
12/04/2019, 4:36 PMI am assuming you imported a bank statement?
m
MaryPeace
12/04/2019, 4:36 PMYes
n
Nicolas Bean
12/04/2019, 4:36 PMAnd the transaction you are looking to match is indeed in the imported statement?
m
MaryPeace
12/04/2019, 4:41 PMI can't open up my QFX file, but I can't think of any reason it wouldn't be. I confirmed the dates, and re-imported the week surrounding that date
MaryPeace
12/04/2019, 4:41 PMThe last attempt yesterday which included that transaction, showed ALL as duplicates
n
Nicolas Bean
12/04/2019, 4:42 PMHm alright.. so you're unable to see that particular transaction on the bank rec page? What kind of transaction is it?
m
MaryPeace
12/04/2019, 4:42 PMdeposit
n
Nicolas Bean
12/04/2019, 4:46 PMHm ok well, what you can do is navigate to the bank register for that account, locate the transaction in the system, and see if there is a checkmark in the "clr" column and a date in the "reconciled date" column. In this case, the transaction would have already been marked as reconciled.
Nicolas Bean
12/04/2019, 4:47 PMIf there is no checkmark on the "clr" column but there is a date on the "reconciled date" column then that might indicate that it is a held bank rec
Nicolas Bean
12/04/2019, 4:47 PMThird thing to check is if the transaction date is prior to the start date
m
MaryPeace
12/04/2019, 4:49 PMDefinitely not prior to start date since it was in the last week of the month. I'll check the register. Our NS has oddly in the past shows things marked as reconciled but not cleared.
MaryPeace
12/04/2019, 4:49 PMThanks!
MaryPeace
12/04/2019, 5:10 PMHuh- in the register, its hows as uncleared and tour a reconcile date.
MaryPeace
12/04/2019, 5:10 PMand *without
MaryPeace
12/04/2019, 5:13 PMContacting NS support
MaryPeace
12/04/2019, 5:13 PMthanks for your suggestions
n
Nicolas Bean
12/04/2019, 6:15 PMalright, let me know what the issue was please.. I'm curious!
m
MaryPeace
12/10/2019, 4:07 PMThey couldn't figure it out either. I ended up changing the account to manual reconciliation to get by this month, so that I could reconcile that transaction.
2 Views