Memorial Day Sale 90% OFF QuickBooks for 3 months.* Limited time only

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
LindsayB1
Level 2

A/R and Balance Sheet Balances are off

Hello!

 

I have noticed that the Balance showing on the A/R report, and the A/R Balance on the Balance sheet are off.

I believe there is one customer balance affecting this. When I bring up the "Customer Centre" , and pull up this specific customer, the balance total shown is $5153.31.  However, when I open the "Receive payments" it does not show this amount anywhere, and only shows that the customer owes.

 

When I try to fix this, both the Balance on the G/L and the subledger change, when I actually only want to reduce the amount on the G/L.  Also, when I try to fix this- I am having a problem balancing this customers account because when I try to reduce the balance I see on the "Customer center" it will create a credit- but then I have nothing to apply that credit to, and it just stays on the customer's account.

 

If anyone has some suggestions on how I can fix this- that would be greatly appreciated !! 

 

I have attached a screenshot to show what I am talking about.

 

Thank you, and have a great day!!

 

Lindsay

 

 

 

 

4 Comments 4
FishingForAnswers
Level 10

A/R and Balance Sheet Balances are off

@LindsayB1  I don't suppose you have any JEs associated with this customer?

LindsayB1
Level 2

A/R and Balance Sheet Balances are off

Yes!  There is- however I don't know how to fix this

FishingForAnswers
Level 10

A/R and Balance Sheet Balances are off

@LindsayB1  Would be a good start to share a report of the JEs in question, redacted where necessary for PII, of course.

 

In general, JEs and reports in QB tend to not get along well.

LindsayB1
Level 2

A/R and Balance Sheet Balances are off

TypeDateNumSplitDebitCredit
General Journal01/01/20241425Undeposited Funds1,723.81 
General Journal01/24/20241424Undeposited Funds 1,723.81
General Journal03/18/20241438Scotia Bank - Chequing4,206.92 
General Journal03/21/20241445Scotia Bank - Chequing 5,550.03
General Journal03/31/20241446Undeposited Funds 1,723.81
General Journal05/03/20241458Scotia Bank - Chequing 23.92
General Journal05/08/20241457Scotia Bank - Chequing 10,719.90
General Journal05/28/20241461Scotia Bank - Chequing 4,396.72
General Journal06/28/20241470Scotia Bank - Chequing 4,958.65
General Journal07/30/20241476Scotia Bank - Chequing 3,993.03
General Journal07/30/20241479Scotia Bank - Chequing 1,006.85
General Journal07/30/20241458RScotia Bank - Chequing23.92 
General Journal08/01/20241492Scotia Bank - Chequing632.36 
General Journal08/01/20241425RUndeposited Funds1,723.81 
General Journal08/30/20241494Scotia Bank - Chequing 1,167.95
General Journal09/03/20241501Scotia Bank - Chequing 752.65
General Journal09/03/20241502Scotia Bank - Chequing 1,132.03
General Journal09/03/20241503Scotia Bank - Chequing 4,807.84
General Journal09/03/20241504Scotia Bank - Chequing 996.60
General Journal09/13/20241500Scotia Bank - Chequing 479.85
General Journal10/10/20241526Scotia Bank - Chequing 1,490.00
General Journal10/11/20241518Scotia Bank - Chequing479.85 
General Journal10/17/20241514Scotia Bank - Chequing 293.25
General Journal10/17/20241519Scotia Bank - Chequing 845.25
General Journal10/21/20241525Scotia Bank - Chequing 669.99
General Journal10/23/20241520Scotia Bank - Chequing338.00 
General Journal10/30/20241524Scotia Bank - Chequing 8,845.64
General Journal11/15/20241535Scotia Bank - Chequing 369.75
General Journal11/21/20241530Undeposited Funds 1,723.81
General Journal11/29/20241538Scotia Bank - Chequing 13,917.52
General Journal11/29/20241541Undeposited Funds9,895.60 
General Journal12/02/20241554Scotia Bank - Chequing 4,902.83
General Journal12/02/20241555Scotia Bank - Chequing 4,944.89
General Journal12/02/20241561Undeposited Funds 9,895.60
General Journal12/05/20241545Scotia Bank - Chequing 104.95
General Journal12/06/20241548Scotia Bank - Chequing 6,973.80
General Journal12/06/20241556Scotia Bank - Chequing 10,676.34
General Journal12/20/20241550Scotia Bank - Chequing 340.70
General Journal12/20/20241552Scotia Bank - Chequing 6,111.39
General Journal12/20/20241557Scotia Bank - Chequing 1,761.95
General Journal12/20/20241558Scotia Bank - Chequing 531.12
General Journal12/31/20241564Undeposited Funds4,170.83 
General Journal01/01/20251564RUndeposited Funds 4,170.83
General Journal01/03/20251569Scotia Bank - Chequing 13,979.55
General Journal01/16/20251567A/R Clearing A/C17,454.78 
General Journal01/16/20251568A/R Clearing A/C 17,454.78
General Journal01/17/20251570A/R Clearing A/C13,783.74 
General Journal01/17/20251571A/R Clearing A/C 13,783.74
General Journal01/17/20251572A/R Clearing A/C4,807.84 
General Journal01/17/20251573A/R Clearing A/C 4,807.84
General Journal01/17/20251574A/R Clearing A/C9,420.17 
General Journal01/17/20251575A/R Clearing A/C 9,420.17
General Journal01/17/20251581Scotia Bank - Chequing 533.10
General Journal01/17/20251603Scotia Bank - Chequing 288.95
General Journal01/24/20251583Scotia Bank - Chequing 6,145.82
General Journal01/31/20251579Scotia Bank - Chequing 1,540.35
General Journal02/28/20251613Scotia Bank - Chequing 84.75
General Journal02/28/20251614Scotia Bank - Chequing 515.15
General Journal02/28/20251615Scotia Bank - Chequing 1,167.20
General Journal02/28/20251618Undeposited Funds1,723.81 
General Journal03/03/20251562Undeposited Funds3,560.35 
General Journal03/03/20251563Undeposited Funds1,109.48 
General Journal03/03/20251565Undeposited Funds369.75 
General Journal03/03/20251643Scotia Bank - Chequing 2,095.81
General Journal03/11/20251624A/R Clearing A/C 1,340.15
General Journal03/14/20251632Scotia Bank - Chequing 20,916.28
General Journal03/21/20251626A/R Clearing A/C4,725.62 
General Journal03/21/20251627A/R Clearing A/C 4,725.62
General Journal03/21/20251628A/R Clearing A/C 2,104.22
General Journal03/21/20251629A/R Clearing A/C2,104.22 
General Journal03/21/20251630A/R Clearing A/C14,828.08 
General Journal03/21/20251631A/R Clearing A/C 14,828.08
General Journal03/21/20251633Scotia Bank - Chequing 335.96
General Journal03/21/20251634Scotia Bank - Chequing 4,725.62
General Journal03/21/20251635Scotia Bank - Chequing 763.88
General Journal04/04/20251648Scotia Bank - Chequing 92.57
General Journal04/04/20251649Scotia Bank - Chequing 259.90
General Journal04/11/20251657A/R Clearing A/C4,208.44 
General Journal04/14/20251671A/R Clearing A/C20,916.28 
General Journal04/14/20251672A/R Clearing A/C 20,916.28
General Journal04/21/20251676A/R Clearing A/C 9,420.17
General Journal04/21/20251677A/R Clearing A/C9,420.17 

 

A/R Report1,527,984.25
Balance Sheet A/R1,538,258.93
difference10,274.68

 

Any ideas on how to fix this would be greatly appreciated !!

 

Have great day!

 

Lindsay

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us