How to mark a years worth of bank transactions as cleared in bank reconciliation?

(0) Share

Report

Posted on by Community Member

I have several bank accounts and reconciliations to bring up to date (hasn't been reconciled properly for a year). Is there a quick way of marking a set of transactions at once (up to 4000 transactions) rather than clicking every line separately?

Also there is a rogue reconciliation with a future date on it, I presume the end balance on this one won't be used as the starting date for the next one until we get to that date in a few months time? Can I delete this reconciliation?

thanks

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi AXfinance,

I think you should contact a developer that can help you with this issue. From the front end side there is no way that you can automatically select more than one single cleared Checkbox in the account reconciliation form.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

AXf, one way to accomplish this is via SQL query. I've done this many times for clients by marking 'Reconciled = 1' in the bankaccounttrans table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks, I already tried to edit the 'reconciled' box manually in the table but it is greyed out. Would I still need to mark them all one by one in the table? I'm not a developer, hoping to get some dev help, but would help me to understand the process.

Also any idea where the 'balance' shown in the fact pane on the bank accounts list comes from? the date shown here doesn't correlate to anything, not TB date, not date of last reconciliation, not period end date, not system date, so difficult to tie up to anything.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

You would need a developer to run the SQL script for you to clear all the transactions at once.

You can delete a reconciliation if there are no cleared transactions in it. If there are, uncheck the boxes in the transactions list. That should allow you to delete the reconciliation.

The balance in the fact box is the net of all transactions in that bank account.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello AXfinance,

the Balance that you can see in the fact pane comes from the info part "BankAccountTableBalance" that uses the DataMethod "balanceCur" from the BankAccountTable. The balanceCur DataMethod there refers back to the BankAccountTable balances Method and calculates the Balance that you see as follows:

If the data you see in this infobox does not match your TB data, try to select the button "click to load all data" to get the information shown there refereshed. It should give you the current Balance of your bank account as of today. This data should be in line with the Balance that you see in GL/common/main accounts in the Balance info part on the right-Hand side provided that the ledger account associated to your bank account has not been changed.

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks Ludwig, I still don't understand what the 'date' shown in this box relates to?

I marked all my transactions as reconciled, and posted a dummy GL journal, one side to the Bank account, one side to the corresponding GL Ledger account for the bank to correct my ending reconciliation balance without changing the balance in the TB, but:

When I click 'reconcile account' I get an error message saying: "Ledger account not specified, bank transaction type is not specified."

Does this relates to one of the lines in the rec (how do I work out which one?), or the dummy GL journal I did to correct the balance?

Any help appreciated.

thanks

AXF

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Don't worry, I just solved the main question by adding the 'manual' column on to the rec and found one manual entry that had no bank trans type on it. Now reconciled, I still don't know what the date relates to though.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

AXf, can you post a screenshot of the field you're referring to, just to confirm? Thanks

Was this reply helpful? Yes No
Suggested answer

Oceanfish26 624 on at

Like (1)

Report

I had 2700 transactions, none of them had a Check Number. I was able to mark all of them by using Mark Check Interval and I used blank as the lower value and 999999 as my high value, then they all cleared!

Was this reply helpful? Yes No