Why can't i create a statement for a client with an open balance? when i try it says no statement available for date.
I have the same problem.
I set up an estimate for a contract that was accepted, then created progress billing invoices from that estimate. I tracked payments received. Why doesn't the Balance forward in the top line of the statement, indicate the total amount of the estimate? I have played around with the dates to try to make the initial balance come through, but it is always $0.00 no matter how I shift the statement dates.
I also went to edit the customer's balance forward in the customer details, and was locked out of that feature.
My goal is to provide my customer with the original estimate amount as the balance forward, and demonstrate their account status in a statement with each invoice transaction and payments made, and the balance due at the bottom.
Is it possible to show a balance forward amount with Quickbooks Online?
Currently, there isn't a way to include the original total amount of the estimate in the Balance Forward Statement. This is because this type of statement only shows all the invoices and payments with balances within a specific period. For more information, check out this article: View Customer Statements.
As an alternative, you can run the Estimates & Progress Invoicing Summary by Customer report and customize it from there. This way, you can email it to the customer. Let me guide you how.
Go to Reports from the left menu.
In the Search box, enter Estimates & Progress Invoicing Summary by Customer and select it.
Set the Report period.
Go to the Rows/Columns section, then check the Date, Num, Status, Amount, Invoiced Amount, % Invoiced, and Balance boxes.
Select the Customer from the Filter section.
Click Run Report.
Choose the Email icon beside Print.
Click Email beside Save as PDF.
Enter your customer's email address, then click Send.
The screenshots below show you the last seven steps.
The Sales menu helps you easily manage your sales transactions, such as estimates. You can also edit and delete them to ensure your customer balances are correct. For more details, visit this article: Sales Overview.
I'm always here to help if you need anything else. Have a good day, @Sundewurks.