Hi, We are trying to reconcile Credit Card statement using match bank data page. Target transaction for matching is an advance interco JE and it is not showing up in the match bank data page's transaction panel. Note that JE was posted in 31st Jan and CC statement date is 1st Feb (you should be able match statement line with past transactions.). Is there any way to reconcile it? @Karina

What are the debits and credits you have for JE?

credit to the credit card acct and debit to bank acct

And on the credit card Account do you have the checkbox checked: "Use Match Bank Data And Reconcile Account Statement Pages"

That's where looked first - it is checked

@Sam-I-Am - I am not sure how the IC journal can have just cr card and bank accounts. It should actually look like this DR Credit Card, CR IC AP, DR IC AR, CR Bank. So you should have the first half of that journal available for reconciliation on cr card acct and the second half - on the bank acct. Is that what you have and neither side (cr card, bank) is showing up?

Possible Solution #1 | Under Setup > Accounting > Accounting Preferences check to see if you have “Require Approvals on Journal Entries” turned on. If you do approve the JE in question. Possible Solution #2 | Also under the Accounting Preferences do you have the option checked Include All Transaction Types In Reconciliation” ? If not check the box. Possible Solution #3 | Do you have the Start Date field on the Reconciliation Page cleared out and empty? If not you should clear it out and see if the JE appears. Good luck!

@Karina I have DR for IC AR (Eliminate), CR for Credit Card, CR IC AP(Eliminate) and DR for Bank Acct(suspense).

and you are still not seeing this journal “DR for IC AR (Eliminate), CR for Credit Card” as a line to reconcile to, correct? do you have other journals available for recon on your cr card account by any chance?

Yes correct - no other JE for recon. It worked last month for similar JE. This is a mystery 🤔

for fun - do you see the ‘CR IC AP(Eliminate) and DR for Bank Acct(suspense)’ on your bank account?

YUP GL impact is exactly that, I am waiting for NS netsuite support - lets see what they say - cross my finger LOL