QB Online Out-Of-Balance

@pirizarry 

Does the balance sheet (BS) balance on accrual basis?  Does the $2,000 Unapplied Cash Payment Income go away in 2018?  If so, sometime in 2017, a payment was received and somehow the date was changed to a date before the invoice it was applied to.  Try changing the date of the $2,000 payment to 20 years in the future and save it.  Then, change it back to a date in 2017 after the date of the invoice it was applied to.  See if that fixes it.  You may need to mark the payment as reconciled in your register after changing the date back to 2017, so your reconciled bank balance stays accurate.  

Thank you for the reply.  

(1) The BS does balance on the accrual basis

(2) The $2000 Unapplied Cash Payment Income becomes a part of Retained Earnings and rolls forward from 2017 as an increase in RE that is now $2k greater than the balance that was on the trial balances that were prepared for each of those years

(3) The payment was for more than $2K, but the unapplied amount from the payment is $2k.  The original documentation of the payment is no longer available, so I don't know all of the invoices it was originally applied to.

To recap:  Total assets at each year-end from 2017 until 2023, on the cash basis, agrees to the trial balance that was used to prepare the tax returns for those years.  Total liabilities & equity for those years is now overstated by $2000, as is Retained Earnings for each of those years.  The cash basis balance sheet does not balance, but the accrual one does. 

I am reluctant to edit the 2017 payment, which currently shows only its original entry in the audit trail. But if nothing else comes through, I might try it. 

@pirizarry 

Understood.  Short of editing the payment, I'm not sure what else can be done.