Help Your Cash Flow with Statements in QuickBooks Online

Help cash flow problems by creating statements in QuickBooks Online QBO

You enter into an informal contract with a customer when you send an invoice. You expect that you will receive payment in a timely fashion for goods or services you’ve sold.

That probably works most of the time. But what happens when it doesn’t, when you’ve sent a reminder and are still waiting? And what do you do when a customer orders frequently and is confused about what’s been paid and what hasn’t?

If you’re using QuickBooks Online, you can easily send a statement - a list of sales transactions, credits, and payments. There are three kinds of statements you can send using QuickBooks Online:

  • Balance Forward. This document emphasizes what’s currently owed by displaying it at the top. Below that is a list of sales transactions that occurred between two dates you specify.

  • Open Item. You select a date, and the statement shows all transactions that were completed before it.

  • Transaction Statement. There’s no total balance here, just the amounts billed and received for every transaction.

Setting Up Statements

Before you create your first statement, make sure QuickBooks Online is set up the way you want it to be. Click the Gear Icon in the upper right of the screen and select Account and Settings found under the Your Company column. Click the Sales tab and scroll down to Statements. Click Statements to open the options there.

Setting up statements in QuickBooks Online

You can List each transaction as a single line or List each transaction including all detail lines. Click the button in front of the option you prefer. You can also choose to Show aging table at bottom of statement. This will show customers how many days each transaction is overdue.

Click Save once you have chosen the settings you want.

Creating Statements

There are three ways to create statements. You can:

  1. Click the Plus (+) icon at the top of the screen.

  2. Dispatch one while you’re in a customer record.

  3. Launch a batch action from the Customer screen.

If you’ve already started entering transactions and there’s some data in QuickBooks Online, click the Plus (+) icon in the upper right corner of the screen.

Tip: If you don’t see the Plus (+) icon, you’re in an active screen. Click the X in the upper right to close it, saving it first if necessary.

You can send three kinds of statements in QuickBooks Online - Balance Foward, Open Item, Transaction Statement.

Click Statement, which is located under Other on the far right. Under Statement Type, select Balance Forward. Below that is the Customer Balance Status field. Choose if you would like to see customers with Open balances, those who have Overdue invoices, or All customers? The third option will include credit memos.

Select a Start Date and End Date. In this example, these were 04/09/2018 and 09/09/2018, and the statement date was 09/10/2018. Click Apply. QuickBooks Online will display a list of matching customers. Click Print or Preview at the bottom of the screen to see your statements.

In the preview below, the customer’s balance forward on 04/09/2018 was $8,245.05. A catch-up payment was made on 08/09/2018 and another invoice sent on 09/01/2018, which accounts for the TOTAL DUE at the top.

Sample QuickBooks Online (QBO) statement for Balance Forward

From this screen, you can either Print the statements or Close to go back to the previous page, where you can Save and Send.

Two Other Options

As we stated earlier, there are two other ways to create statements. Click Sales in the left vertical toolbar and highlight the Customers tab by clicking on it. Hover your cursor over a customer and click the down arrow at the very end of that line. From the list that opens, select Create statement.

You can also hand-pick multiple customers to receive statements. With the Customers window open, click in the box in front of your choices, and then click the down arrow next to Batch actions at the top of the list. Select Create statements.

The mechanics of creating statements in QuickBooks are fairly simple. But you don’t want to send an inaccurate one to a customer. Make sure your transactions are up to date before you generate any statements, and choose your date ranges carefully. As always, we’re available to help with this task – or any other area of QuickBooks Online that might be confusing to you.