Deposits all show "Not Specified" in balance sheet report by location

---

@treasurer84 wrote:

We turned on Locations in QBO Plus around May 9 and defined 6 locations.

Went back to all transactions from April 1 and added Location.  Including all Sales Receipts and Expenses.

Sales receipts included in deposits are NOT included in Location total for Balance sheet by Location report.  Expenses ARE included in total.

Edited deposits.  Edit screen now includes "Show payment for this location" with dropdown of our locations.

Sales receipts with location show in deposit edit screen regardless of which dropdown is selected, or if "Unspecified Location" is selected.

Deleting and re-entering the deposit does not change this behavior.

But if a specific Location is selected from the dropdown, and the deposit is saved, the total deposit amount then appears in the Location total for Balance sheet by Location report.

 

Should the Location specified in a Sales Receipt determine where that amount appears in the Balance Sheet by Location report?

Or does the Location dropdown in the Deposit screen override and apply all receipts to the selected Location?  If this, then cannot mix locations in a Deposit...?!

 

What is the best way to ensure a Sales Receipt flows through to the Balance Sheet total for the Location specified in the Sales Receipt?

 

Thanks!

---

@treasurer84 

"What is the best way to ensure a Sales Receipt flows through to the Balance Sheet total for the Location specified in the Sales Receipt?"

There is no best way. In QBO, Location tracking is mainly for P&L items (revenue & expenses) only, not for the Balance Sheet accounts generated from various transaction types like Sales form for Sales Receipts, Vendor form for Expenses. The only exception is writing Journal Entry form, that will track location. Other than that, the bottom line is running the Balance Sheet by Location (or Class) in QBO is a waste of time, they should have removed this report many years ago.

---

---

"

@treasurer84 

"What is the best way to ensure a Sales Receipt flows through to the Balance Sheet total for the Location specified in the Sales Receipt?"

 

There is no best way. In QBO, Location tracking is mainly for P&L items (revenue & expenses) only, not for the Balance Sheet accounts generated from various transaction types like Sales form for Sales Receipts, Vendor form for Expenses. The only exception is writing Journal Entry form, that will track location. Other than that, the bottom line is running the Balance Sheet by Location (or Class) in QBO is a waste of time, they should have removed this report many years ago."

 

Well, this is an annoying discovery. My entire understanding on QBO Locations is that they would pull through the balance sheet so one could have a balance sheet for each location. Thanks for clarifying.

 

---