Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Does anyone use Akaunting to reconcile accounts?

Brett Johnson   ( User )

Commented 2 years ago

I have been having problems reconciling my accounts. At first, every transaction in the specified time frame was assumed cleared. The Clear checkbox did not do anything. For me to get an account reconciled I would have to move transactions around so they appeared in the correct time frame.

I finally decided to take a look at why the Cleared checkbox wasn't working and corrected it in my build.

Now, when I have a transaction that hasn't cleared in a reconciliation time frame, I can still reconcile by making sure that transaction does not have the Cleared checkbox checked. Now, when I go to reconcile the next period, the opening balance is off because the system appears to include all the previous transactions whether they have been marked cleared or not.

Here is a use case:
On 12/31/21 I write a check for $1000.
On 01/15/22 The check clears the bank and shows up on my 01-01-22 to 01-31-22 bank statement.
When I go to reconcile 12/1/21 - 12/31/21, the check shows up in the transaction list as it is dated 12/31/22.
However, it will take several days for the check to be deposited, and clear my account, so it won't show up for me to reconcile until sometime in January or even February (or if ever).

Before my fix, the only way I could reconcile Dec'21 was to change the date of the outstanding check to 1/1/22.
After correcting the Cleared checkbox behavior, I can leave the check with it's original date of 12/31/21, and just don't check the Cleared checkbox. This lets me reconcile Dec'21, leaving the outstanding check as "not cleared".
However, when I go to create a new reconciliation for Jan'22, the starting balance is off by the amount of the uncleared items from the previous period (in my use case $1000). I believe this is because the system is including the outstanding check because it's date is before the current reconciliation period, even though if has not cleared. In this scenario, the beginning balance off, and is impossible to reconcile without changing the date on the outstanding check.

I am just curious if anyone else is able to use the reconciliation feature with outstanding (uncleared) items that cross over the reconciled time frame.

Please login or register to leave a response.

Showing 1 to 1 of 1 discussions