Skip to main content
Question

Reconciliation issues

  • 22 February 2024
  • 8 replies
  • 216 views

Forum|alt.badge.img
  • Semi-Pro II
  • 218 replies

Hello all,

i have been trying to reconcile a sample cash account but the system displays the following error:


I want to reconcile just the difference of​ 634.98. How can I do that?

The Batch Payment has the status of Balanced but the payment lines under this batch has the voided status.​​​​​​

8 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 22, 2024

Hello,

  1. In Finance → Journal Transactions, enter a debit and credit to the same Cash Account of  of​ 634.98. This entry has no impact on Cash balance or GL balance but it makes part of your highlighted entry available for reconciliation.
  2. Return to Reconciliation statement and clear the ​ 634.98 (you will see this figure twice, Receipt and Disbursement. Clear the one that adjusts Difference to 0).
  3. When batch 000017 is released, presumably on the next reconciliation, you will clear both batch 000017 and the opposite side of your entry from #1 in your next bank reconciliation.

Laura


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • February 24, 2024

Hey @Laura02 ,

Thank you for the suggestion. I would be trying out the same today. But I would also like to know if my AP Batch is not released but the payments under that batch are voided, like in my current scenario, is it normal that the system would display this warning message? Also , i am not looking out for completely reconciling it , but just to release the Import bank transactions form. Also if i would be entering a new GL entry as you mention in step 1, I might not be looking to reconcile to the next period, since it has already been reconciled.


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • February 24, 2024

How can I release this?


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • February 24, 2024

Also, I checked out the other entries, and found the figure exactly same to the difference. But it also says the same error message:

 

How can I make use of this particular line? 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 25, 2024

Hello,

I thought you were saying before, that the difference of $634.98 was one of several documents contained in one lump sum deposit.

If $634.98 is not one of several documents contained in one lump sum deposit, then my answer above isn’t correct.

 

Are you now saying that GL entry 234537 is the missing transaction that you need to clear in your 12/29 bank reconciliation # ?  Look at the dates. Is the date of your reconciliation correct, 12/29?  Is the date of GL entry 234537 correct, 1/11? If so, how could gl entry 234537 be part of this reconciliation when the transaction didn’t happen until later?

 

Laura


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • February 26, 2024

Hey @Laura02 ,

The suggestion you mentioned, it might work well, but the statement that I am considering has the reconciled balances from 3 different years from 2020 till 2023.


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • February 26, 2024

And the line that displays the exact amount has been posted on 1/11/2023 and the reclassified and posted on the same date. So why does my reconciliation statement still shows doc on hold. Even the status is getting displayed as Posted:

 

I tried to re-open the periods, but it still shows the same error.


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • February 26, 2024

Hello @Laura02 , just to update you, I now tried posting an GL entry, not a reclassification one, with the same amount, and I am able to check this newly created entry. Whereas the one for which the system is triggering the error, I am not able to get that. i have been wondering why so.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings