Hello there, Peter. We appreciate your time and effort in splitting the cost of your utilities manually. Let’s work together to find a way to automate this process.
To begin with, you can use the Bank Rules feature in QuickBooks Online. It automates income and expense tracking by matching transactions, assigning categories, and splitting line items.
Here's how to set up bank rules:
- Navigate to Accounting, then pick Rules.
- Click New rule in the upper-right corner and enter a name in the What do you want to call this rule? Field.
- In the Apply this to transactions that are ▼ dropdown, choose Money in or Money out.
- From the in ▼ dropdown, select a bank or credit card account, or All bank accounts.
- Specify the rule's conditions. You can set a single rule with up to 5 conditions. Set and include the following, then click + Add a condition.
- In the Conditions fields, pick whether the rule applies to Description, Bank text, or Amount. Then, choose Contains, Doesn't contain, or Is exactly to decide how QuickBooks applies the rules.
- Click the Transaction type, then the +Add a split to add more split details, and choose whether Percentage(%) or Amount($) under Split by.
- Select Category, Tags, and the Payee to apply. Then, Save.
Once done, QuickBooks automatically applies your rules to bank transactions in the Pending tab. For it to work effectively, ensure all the details provided are correct.
Keep us posted if you have other questions about managing utility expenses. We'll be around to help.
