Back

Add Prior Outstanding Balance to Billing Statements

Contents

Introduction

Step 1: Obtain Billing History

Step 2: Create Current Prior Outstanding Balance Upload

Step 3: Add Current Prior Outstanding Balance to Billing History Reporting

Account Billing History Bulk Report

PDF Report Billing Section

 

Introduction

When you're generating billing statements, it is helpful to include not only this billing period's balance, but any outstanding balance remaining from previous periods. Prior outstanding balance allows you to upload and report outstanding balance to clients on PDF reports and for internal use in bulk reports.

Note

Advisor View does not roll forward unpaid balances. Prior outstanding balance is based on the outstanding balance you upload for invoices.

Adding prior outstanding balance includes the following steps:

Top of Page

Step 1: Obtain Billing History

The first step in adding prior outstanding balance is to obtain the outstanding balances using an Account Billing History bulk report.

When creating the bulk report, add at least the following columns:

Top of Page

Step 2: Create Current Prior Outstanding Balance Upload

The second step in adding prior outstanding balance is to create an Excel file containing prior outstanding balance for upload to Advisor View.

Note

When you upload current prior outstanding balance, it is applied to the most recent billing history data.

  1. From the Account Billing History bulk report generated in Step 1, create a new Excel file containing the following data, in this order:

  2. Create a Billing Prior Outstanding Balance upload. Use your preferred method (copy & paste or file upload) to add the data to the upload and click Upload.

    For more information about uploads, see Bulk Data Uploading.

Top of Page

Step 3: Add Current Prior Outstanding Balance to Billing History Reporting

Once uploaded, you can see the prior outstanding balance in two places: the Account Billing History bulk report, and on PDF reports with a billing section.

For more information on billing history, see Generating Billing History.

Top of Page

Account Billing History Bulk Report

When you run an Account Billing History bulk report, add the Current Prior Outstanding Balance column to the Selected list. The current prior outstanding balance is reported for the billing history periods that it was uploaded for.

For more information on bulk reports, see Bulk Reports.

Top of Page

PDF Report Billing Section

When you run a PDF report that includes billing history, you can choose to report prior outstanding balance.

To display prior and total outstanding balance on a PDF billing report:

  1. Under Client Reporting, click Templates.

  2. Select the template that you want to add the prior outstanding balance to.

  3. Click the Billing module.

  4. Select the desired check boxes:

  5. Click Save.

For more information on PDF reporting, see Running Dynamic and PDF Reports and Learn More About PDF Reports and Templates.

Top of Page