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,
I’ve not seen a single article from QuickBooks Help related to this subject on how to record Sales Tax refund check in QuickBooks Online. Most of the answers found don’t work or whoever answered the questions does not fully understand how Sales Tax Center is so limited to making any credit/refund adjustments. It’s not clear this functionality is even available in QBO.
What I found as a workaround is to create a Sales Receipt in QBO. Ths assumes negative balance is already shown in Sales Tax Center. In other words, you’re expecting this refund from the Tax Agency.
These are the steps to follow in creating a Sales Receipt:
For Customer field, create a new one (example zSales Tax Adjustment) or leave it blank still works.
Select deposit to bank account.
Select same Products/Services items, one as a taxable item and another one non-taxable item.
With taxable sales item, it should compute sales tax refund amount at the bottom. In this example shown in the screenshot below, taxable sales amount is $21,750, the tax rate is 8% and received $1,740 refund from Tax Agency.
Transaction reference numbers help you easily identify transactions. QBO will automatically assign transaction numbers in sequence. But if you want to change the starting custom transaction number of your own, you can do so. You would want to turn the company settings ON once, assign a custom number and turn it OFF again so that QBO can identify number sequence based on the last transaction number.
A separate number sequence appears on:
Invoices, sales receipts, refund receipts, and credit memos
Delayed charges and Delayed credits
For Statements, QBO will automatically control the numbers that reference identify so you can’t change it.
QBO lets you customize your transaction numbers.
How do custom transaction numbers work?
When you turn ON custom transaction numbers:
You can change transaction numbers when you create or modify a transaction.
Transaction numbers can include letters (such as 2017-1001).
New transactions get new numbers (such as 2017-1002), based on the last transaction. You’ll be warned if you try to enter a duplicate transaction number.
When you turn OFF custom transaction numbers:
Transaction numbers are never changeable, even numbers created with custom transaction numbers on.
Transaction numbers are assigned when transactions are created.
Transaction numbers are sequential, based on the last number, starting at 1.
To turn custom transaction numbers ON or OFF from the company settings:
Click the Gear icon at the upper right corner > Your Company > Account and Settings).
For customer transaction numbers on sales forms:
Click “Sales” on the left, and then click the edit icon for “Sales form content”. Select the “Custom transaction numbers” checkbox, and click Save.
For custom numbers on purchase orders:
Click Expenses on the left, and then click the edit icon for Purchase orders. Click the “Use purchase orders” checkbox. Select the “Custom transaction numbers” checkbox, and click Save.
To reset your transaction numbers again:
Select the Custom transaction numbers checkbox, and click Save
Create a transaction with a new starting number.
Clear the Custom transaction numbers checkbox, and click Save.
The setting for “Deposit to” on the Sales Receipt form is “sticky”.
All you need to do is save your first Sales Receipt to “Undeposited Funds” accoount under “Deposit to” field. Once saved, the next time you open the Sales Receipt screen – it will default to Undeposited Funds account.
How can I disable the request for customer email in sales receipts. I don’t want to send or enter the customers email. I want to save Sales Receipts. And the transaction can’t save until I enter an email.
On the Save and Send button, click the drop down arrow and use either Save and Close or Save and New. It also applies to Invoice.