Run a balance sheet by location in QuickBooks Online

Hi Team,

If there any inter bank account transfers, I am not able to view the 'Location' setting trigger which facilitates to transfers between locations ?

Thanks

Hello there, @SS2405. I'll guide you in assigning location on your accounts receivable and payable transactions in QuickBooks Online (QBO). 

In QBO, the location field is only visible in the sales or expense forms such as Invoices and Bills. That said, you must select a particular location when creating invoices (Accounts Receivable) and bills (Accounts Payable). Here's how:

Assign a location to an Invoice:

1. Navigate to the +New menu and select Invoice.
2. Enter the needed details.
3. Next, in the Location dropdown, select the location for this invoice.
4. Once done, click Save and close.

When you run the Balance sheet report, the invoice amount will be shown in the Accounts receivable line under the selected location. Let me guide you on how:

1. Navigate to the Business Overview and select Reports, or go to the Reports menu.
2. Look for the open the Balance Sheet.
3. Next, in the Display columns by dropdown, select Locations.
4. Then, select Run Report.

Assign a location to a Bill:

1. Navigate to the +New menu and select Bill.
2. Enter the needed details.
3. Next, in the Location dropdown, select the location for this bill.
4. Once done, click Save and close.

When you run the Balance sheet report, the bill amount will be shown in the Accounts payables line under the selected location. Refer to the previous steps above to proceed. 

Once everything is fine, you can now receive the payment for the invoice and pay the bill. 

I also added this helpful resource that you can use as a guide in categorizing transactions in QBO: Categorize online bank transactions in QuickBooks Online.

I'll be here ready to lend a hand if you have other concerns managing your reports. Just leave a reply below. Have a good one.