Most of the reports in QBO, you can’t customize the way you want it. Just wish, they’ve simple weekly sales reports filter by sales transaction type like Sales Receipt but they don’t.
The ideal report in QBO would be SALES BY CUSTOMER SUMMARY group by week. But this report you can’t filter it by Transaction Type to get Sales Receipts only.
In the meantime, you can run TRANSACTION LIST BY CUSTOMER report to get the data.
Report period = select as needed
Rows/columns Group by = Week
Customize > Filter > Transaction Type = Sales Receipt
You can make this My Custom Reports by clicking Save Customization button at the top right. Next time you will see this in My Custom Reports tab,
How to set up and use special pricing for selected or all customers in QuickBooks Online?
1. Setup New Customer Type (Dashboard > Sales > Customers > Customer types > New Customer type).
2. Turn on Price Rules (Gear > Your Company > Account and Settings > Sales > Products and Services > Turn on Price Rules).
3. Setup New Price Rules (Gear > Lists > Products and Services > Drop-down arrow under MORE > Price Rules).
4. Create Invoice or Sales Receipt (Create + sign > Customers) > Select (or use default) Price Rules under Rate column.
Educational and Instructional Video:
QuickBooks Online QBO Price Rules (aka Price Levels) – Special pricing for selected or all customers
The billable feature is available only in QuickBooks Online with Plus plan.
When you select “Billable” Expense checkbox field, you must also select a Customer/Project field each split line that is billable. If you don’t select Customer/Project field, you will get an error message. You can’t the save the transaction. (If you’ve Markup percentage turned on from the settings, you can also choose that field to alter that billable invoice amount).
By selecting “Billable” checkbox and Customer/Project field, it will do two things:
1) It will create an expense from that vendor.
Checking billable allows you, when you create an invoice, to move that expense to the invoice without having to retype it.
2) It also allows you to create an invoice to move those expenses automatically to the invoice without having to retype it again. In other words, you will see all open expenses ready to be included when you are ready to create invoices. Just create an invoice, select customer and right side Add to Invoice panel will open. You can choose “Add all” or each billable item.
To turn on the Use Billable Expenses preference:
Choose the Gear icon at the upper right corner > Your Company / Account and Settings.
Choose Expenses from the menu on the left.
In the Bills and expenses section, check on the Edit icon.
Place a check in the box to Make expenses and items billable.
Optional: you can also select Markup with a default rate of xx% box.
Manage your multiple price lists for different customer types with ease.
Eliminates the hassle of maintaining and remembering who gets what price for what items.
To turn the Price Levels ON in QBO (COMING FEATURE):
Gear at the upper right corner > Your Company > Account and Settings > Sales > Products and Services > Show Price Rules drop down on sales forms > ON > Save.
On Customer Information page, new ‘Additional Info’ field (next to Attachments) is added to enter Customer Type and Price Rules.
Can I change the default A/R or A/P account in QuickBooks Online
QuickBooks Online (QBO) is not designed to work with multiple Accounts Receivable (AR) and Accounts Payable (AP) accounts. The initial AR and AP accounts, or those selected during conversion, will be the default accounts. We encourage our customers to merge their accounts payable and receivable accounts. For more information on merging accounts, please see Merging accounts, vendors, or customers. If division of open payables and receivables are needed use one of the following options…
It will show as viewed whoever viewed it (primary or cc). If it’s viewed by both it will show as viewed twice.
Viewed Status Icon: If you open sales transactions (left navigation bar > transactions > sales) under status column, it will show many have opened the invoice and viewed it. It will show one black icon if viewed by one person or two black icons if viewed by both. See attached screenshot.
(Note: In case, you do not see Status column and need to add, go to middle Gear at the far right and select show more and add status column).
Invoice Activities: Open the invoice in question from the sales transactions or directly from customer center. Under activities (below invoice balance due, next in line to attachments), it will show invoice viewed with date and time record. But it is not possible to identify who actually viewed it (primary or cc person), especially if viewed by just one person unless one or both replied with the message. See attached screenshot.
This has to do with reflecting accurate direct expenses related to customers on Income by Customer Report.
If you are depositing a vendor/supplier refund for an expense that was previously Billed to a customer, select “Track returns for customers” box and choose that same customer on the deposit and mark it Billable.
For example, if you buy a material for a customer’s job, you would bill the expense to the customer. But if the customer later returns the material to you and you return it to the vendor/supplier for a refund that you are depositing, you need to mark the deposit billable to that same customer and also select “Track returns for customers” box. Otherwise, it will show as customer billed for the material expense, and the vendor credit will not appear on Income by Customer Summary Report.
Here is an example of what happens when $1,000 billable purchase returned to the supplier for a refund and deposited that money in the bank. The goal is to show zero expense related to that customer.
SHOWING RESULT WITHOUT BILLABLE AND RETURNS FROM CUSTOMERS
SHOWING RESULT WITH BILLABLE AND RETURNS FROM CUSTOMERS
QuickBooks Online Plus: Track returns for customers box on Deposit Form