Hi

Are you in history mode?  do you see History option between Help and report?

Do you use foreign currency on A/R?

Are you looking at Integrity summary?  how many * consistence  (left is GL value , Right is SL value) is GL correct or SL correct?

need more information to able to help

Hi Jason,

No, it doesn't appear that I am in history mode. I dont see the History option.

We do not use foreign currency.

Below is the window I get when I do a data check. Any insight?! I am so lost in finding this -$25,000 A/R Balance, which shows up on our Balance Sheet as Cash to be deposited. Thanks!

Not sure if these two screen shots will help but the $25,000 doesn't show up on our balance sheet on Dec 30 but does on Dec 31. I believe we located the discrepancy in the HST Adjustment account but I have no idea how to remove this. Please help!!!

Hi Mbach2019:

For this amount to show up in your receivables someone must have unlinked the account and made an entry. In order for this to be cleared up we need to know where this entry came from and what it is for? Once we have this information adjustments can be made. Let us know so we can help you!

Hope this helps!

Hi

Your link account for A/R (in Setup, Setting, A/R , Link account (invoice) have linked accounts receivable with a General Ledger account with a value, where Subledger (invoice) is zero outstanding.

so you would have to check cash to be deposit and Account Receivable account , see if the 25,000 transaction are relate and can you void or reverse it.

1. you can void or post reverse entry cancel both value in both account  or allocate to write off account (depends on which is correct)

2. just change A/R link account to zero value chart of account (if you do not want to post any entry)

the ultimate goal here is to make Account receivable 's link account to have zero value (since you do not have any outstanding invoice on sub-ledger)

Hi Jason,

Thank you for getting back to me and trying to help! I really appreciate it. 

I have looked at the linked accounts for A/R but not sure what I am looking for - a screenshot is below. Insight?

I honestly have no idea what this $25,000 transaction is for and I believe someone made it in error but I can't find it anywhere! Why I try to pull up a general ledge of cash to be deposited 1020 account it doesn't show up there. Even when I look in the HST Adjustment GL it doesn't show up there either. Any advice on additional steps I can take? Thank you!!

So I just went through our A/R listing for 2018 (luckily we are small so there weren't a ton of transactions and its an even amount of $25,000). 

I think I might have found the issue. it appears that this sale invoice was entered twice by accident. But when I go to click on J914 it says its not there. So I am assuming the person who incorrectly entered it tried to delete it. Its not showing up in their profile as an outstanding receivable.. so I am not sure if this is the culprit.. thoughts?

You could be right with J1159.

Hi 

Yeah I think you found the issue as Brea suggest J1159

You can go to try to drill download on source of J1159 see whole general journal see if only deposit and a/ris effected or Report, Journal entry/Transaction detail , by transaction number and pick J1159 click ok to show.

then decide which is best way to fix it.

Hi Brea and Jason,

Thanks again for your help with this. I have tried to locate the issue with J914, J1158 and J1159 and I'm unable to find the cause as it that they have been entered appropriately.  After digging the correction (1158 & 1159) were to move the funds from one revenue account to another, and it appears to have been done properly.  Also this transaction was dated 10/10/2018, and for whatever reason the discrepancy does not show until 12/31/2018.  I'm beginning to suspect that it may have to do with 'linked accounts' as suggested earlier.  Is there any other way to dig into this?

Thank you!

Me again. I am prepping for our audit (which is starting this week so that's why I'm getting a little anxious about this) and while I was reviewing the Income Statement I saw that our Donation account is showing $25,000 less than what appears on the GL of the Donation account (see imagine below). The J1159 entry does show up in the GL but I have no idea why its not on the Income Statement.

Any help/insight you can provide would be so much appreciated! My knowledge of Simply is limited (as I'm sure you can tell!)

When you print your income statement please be sure to choose in the box beside the title Template "Default Report Options" not "Last used report options" before hitting the OK button. If the amount is showing in your GL then it must be in the Income Statement. Once this issue is solved we will continue with the next one of the unbalanced data integrity.