This is the add/edit page for building a statement. The page will handle both add and edit modes from the same page. There are a total of four steps in the add mode and a single step in the edit mode. It is possible to skip step 1 and 2 if the customer id number is already known. The steps are as follows:

1. In add mode, do a search for the customer.
2. In add mode, choose a customer from the search results.
3. In add mode, enter a date range, this will get the invoices that will make up the statement line items.
4. In add or edit mode, enter the values into the builder form.

Special Note: The statement, once created, will become a standalone date/time stamped report. The statement physically records things as they are at the time created. The main invoices, payments, and deposits are still live and active but the statement becomes somewhat of a "snapshot" in time (basically, that means that it is dead and does not continue to update itself). Any new payments received, need to be applied to the actual invoices not the statement. The statement is somewhat of a special customer report or tool to get your monies. The actual invoices are where the payments need to be applied to satisfy the accounts receivable portion.

Note About Local Math: The page contains a number of auto calcs once on step 4 or the build form. If for some reason, the local math on the page does not give you the values you need, feel free to plug or manually enter the values where needed. A known issue arises if you are carrying a previous amount owed and you start tweaking what invoices will show up. That previous amount may need to be manually plugged into the dated totals. If you get lost, look for the refresh button on the browser. That will restore the original values and allow you to start over.

Here are some of the fields values and what they need:

1. Statement # - This is an auto generated number that is controlled behind the scenes.

2. Customer - This is the customer name.

3. Statement Date Range - Required. This is the date range for the invoices that act as the line items. Use the m/d/yy format on all dates. Note: Because the statement is a snapshot in time, even if you modify the date range (in edit mode), the statement will not include any other invoices. If more invoices are needed, simply make a new statement that includes them. It is impossible to add additional invoices once in edit mode.

4. Statement Date - Required. This is the date the statement was created and/or sent to the customer. Use the m/d/yy format on all dates.

5. Due Date - Required. This is the date that the statement is due back to you (meaning monies sent back to you). Use the m/d/yy format on all dates.

6. Payment Terms - Required. This is where you could put your payment terms. Standard values are things like Net 10, Net 15, Net 30, Net 45, Net 60, COD, Check Only, etc. The field has a max of 100 characters and a min of 2.

7. Printable Statement Notes - Optional. This field is where you put special statement notes such as thanks, pay or I'll turn you off!, etc. The max is 255 characters.

8. Previous Amount Owed - Required. This is the sum of the amounts owed prior to the statement date range. This number plays a part in the grand total owed by the customer. Note: If you show a previous amount and then start tweaking invoice line items by turning them on/off, it is possible for this value to get lost or dropped out. If that happens, you may need to manually add it back in at the bottom. If it gets crazy and you can't find where the value is... look for the refresh button on the browser. That will restore the original values.

9. Invoices and Totals - At least one invoice is required for the statement to be created. Use the checkboxes to show which invoices to include. Checked means include, unchecked means don't include. The application should help you do the math on the totals but it is your responsibility to verify the results. Both the status and payment types may also be modified by you (text fields). The system is setup to help populate those fields but they may contain whatever you wish. The status has a max of 25 chars and the payment types has a max of 100 chars.

10. Aged/Dated Total - The six fields in the aged/dated total section are the outstanding receivables for the customer. These are the bottom most form fields and are for current, over 30, over 60, over 90, finance/late fee, and grand total due. The math is as follows: The first five must add up to the total due. The application will try to help you do the math, however, you are responsible for the final results. If needed, you may make manual changes to these numbers. If the statement is carrying a previous amount owed, it must be included in the grand total.

General Tip: If you are frustrated with the edit options for the statement... just create a brand new one. There are more options when the page in the add mode. Statements do not affect financials in any way. Create as many as you need.

« Back . [contact Adilas support - email form]