How Can I Change The Due Date Filter For Statements In Quickbooks 2011for Mac

Let’s say you have a regular customer who used to pay on time, but he’s been hit-and-miss lately. How do you get him caught up? Or, one of your customers thinks she’s paid you more than she owes. How do you straighten out this account? Both of these situations have a similar solution.

For many businesses, Quickbooks is pivotal for accounting needs. The QuickBooks Customers & Receivables Reports give you more insight into your customer relationships and billing information. You can run reports to view amounts due from customers, open invoices, average days to pay and many other reports in the Customers & Receivables Reports section. Filter on transaction type = payment and the date range. To match a payment transaction to an invoice number, the invoice number can be entered into the memo field on the receive payment form. Then, the invoice number should appear in the memo field on reports showing payment transactions. “Bills are due 10 days after receipt”. For fraternal units who pay their bills right away set the 10 to 0. Lodges may select any number of days that makes sense to their particular operations. For example if you pay your bills once a month then you could set it to 30. If you pay your bills every two weeks then you could set it to 14.

QuickBooks’ statements provide an overview of every transaction that has occurred between you and individual customers during a specified period of time. They’re easy to create, easy to understand, and can be effective at resolving payment disputes.

A Simple Process Here’s how they work. Click Statements on the home page, or open the Customers menu and select Create Statements. A window like this will open: QuickBooks provides multiple options on this screen so you create the statement(s) you need.

First, make sure the Statement Date is correct, so your statement captures the precise set of transactions you want. Next, you have to tell QuickBooks what that set is. Should the statement(s) include transactions only within a specific date range? If so, click the button in front of Statement Period From, and enter that period’s beginning and ending dates by clicking on the calendar graphic. If you’d rather, you can include all open transactions by clicking on the button in front of that option. As you can see in the screenshot above, you can choose to Include only transactions over a specified number of days past due date. Choosing Customers Now you have to tell QuickBooks which customers you want to include in this statement run.

Your options here are: • All Customers. • Multiple Customers. When you click on this choice, QuickBooks displays a Choose button. Click on it, and your customer list opens in a new window. Click on your selections there to create a check mark.

Click OK to return to the previous window. • One Customer. QuickBooks displays a drop-down menu. Click the arrow on the right side of the box, and choose the correct one from the list that opens. • Customers of Type. Again, a drop-down list appears, but this one contains a list of the Customer Types you created to filter your customer list, like Commercial and Residential. You would have assigned one of these to customers when you were entering data in their QuickBooks records (click the Additional Info tab in a record to view).