We have been running BR for a number of years, so we are past the "Take-On Procedure" notes in the Help section.

The “Calc as of” amount for one of the Banks does not agree to our GL Bank Balance. (The amount is $1521 lower in BR compared to the GL balance.)
Everything else is correct in BR – all the transactions appear correctly, and everything that should be Open is marked correctly.

Question: How do we adjust the As Of Balance?

I was inclined to post a batch entry in BR, creating a so-called Receipt for $1521, and not posting this is in the GL.
My issue with this is that it appears that this will throw off our reconciliation when we go to reconcile the next period.
The reconciliation screen wants to mark this adjustment as Cleared but if we do this we are off by $1521 in the To Clear amount. (And, if I do not mark the entry as Cleared, it will stay forever.)

Are you saying that everything about the bank balance and g/l balance is corret at the moment, but that a back dated bank reconciliation report does not agree?

BankRec is date based. Ledger is period based. Look for a transaaction posted outside its period, but I wouldn't worry about it too much if all the figures agree now.

No.

Both the GL Bank Balance is correct, and the BR is balancing each month.

The most recent BR Bank Rec posting has been for May.
If I take note of the GL Bank Balance for May, June, or July and then I look at the BR and check out the "As of" amount for May 31, June 30 or July 31 the two values are always off by $1521.

My question is how to get the "As of" amount to match the GL Bank, without throwing off the Bank Rec.

Hi Sam,

Post a receipt or payment in BR depending on whether the balance is too high or too low. Make the offsetting entry the bank account itself. The transaction will net to zero when it hits Ledger, but will move the BR balance in the direction you need.

I'd recommend doing this on a copy of the data to make sure you post a transaction of the correct type.

This s a good way of starting to use BR if you haven't completed a reconciliation. Just start with an opening balance of $0.00 for the account and then post the requisite receipt/payment to get the BR balance correct after the first reconciliation.