Back

Common Billing Questions

Contents

How do I set up billing in advance?

How do I set up billing in arrears?

I have a father who wants to pay a portion of his child's bill. How do I set this up?

Does the average daily balance include weekend days?

How is average daily balance calculated?

How do I give a client discount?

How do I create an adjustment and apply a credit to a billing group or billing account?

How do adjustments affect minimum fees?

Can I turn off the proration of capital flows?

How do I set up billing periods?

How can I exclude small cash flows from billing?

How do I bill at a single rate?

How do I export my management fees?

How can I see a report of my billing history?

How can I compare the previous billed amount with the current billed amount?

What bifurcation dates do you use for average cost accounting?

 

How do I set up billing in advance?

To set up billing in advance, follow these steps:

  1. On the Billing menu, click Billing Definitions.

  2. In the Select a billing definition list, choose an existing billing definition. If you haven't created a billing definition, see Create, Edit, or Delete a Billing Definition.

  3. Under Bill in, click Advance.

  4. Click Save.

How do I set up billing in arrears?

To set up billing in arrears, follow these steps:

  1. On the Billing menu, click Billing Definitions.

  2. In the Select a billing definition list, choose an existing billing definition. If you haven't created a billing definition, see Create, Edit, or Delete a Billing Definition.

  3. Under Bill in, click Arrears.

  4. Click Save.

I have a father who wants to pay a portion of his child's bill. How do I set this up?

To do this, follow these steps:

  1. On the Billing menu, click Billing Groups.

  2. Click Edit next to the billing group where the child is assigned.

  3. Add the father's account to the billing group. To do this, select his account in the Available Accounts column and then click Add Selected Accounts.

    If the only reason you added the account to the billing group was to use it as a payment account, select Exclude ALL Securities from Billing on the account's Excluded Securities Panel.

  4. On the Payment Distributions tab, click Add account under the child's account.

  5. In the list that appears, click the father's account.

  6. Specify the applicable payment distributions and then click Save. In the example below, the father (Michael) will pay half of his daughter's (Georgia) bill.

Does the average daily balance include weekend days?

Yes, average daily balance billing includes weekend days and holidays.

How is average daily balance calculated?

We take the summation of the daily ending value of billed securities for the days on which the account is to be billed (adjusted for custom/start end dates and billing inception/close dates) and divide by the number of days in the billing period.

How do I give a client discount?

Do one of the following:

Discount Type Actions to Take
Specific account discount
  1. On the Billing menu, click Billing Groups.

  2. Click Edit next to a billing group where the user is assigned.

  3. Click the Adjustments tab.

  4. In the Adjustments box for the account, specify the discount amount as a dollar amount or as a percent. To specify a discount, type a dash (-) before the dollar amount or percentage - for example, type -10.00 to give a discount of $10.00 to all accounts assigned to the billing group.

  5. In the Description box, type a description for the discount. This description will print next to the discount amount on the billing statement.

  6. Click Save.

Billing group discount
  1. On the Billing menu, click Billing Groups.

  2. Click Edit next to a billing group where you want to specify a discount.

  3. Click the Adjustments tab.

  4. Click Create Adjustment.
  5. In the Adjustment box, specify the discount amount as a dollar amount or as a percent. To specify a discount, type a dash (-) before the dollar amount or percentage - for example, type -10.00 to give a discount of $10.00 to all accounts assigned to the billing group.

  6. In the Description box, type a description for the discount. This description will print next to the discount amount on the billing statement.

  7. Click Save.

Discount to all accounts assigned to a billing definition

To give a discount of a set amount at the billing definition level, follow these steps:

  1. On the Billing menu, click Billing Definitions.

  2. In the Select a billing definition list, choose the billing definition where you want to specify the discount.

  3. On the General tab, type the discount amount in the Adjustment amount box. You can specify the discount amount as a dollar amount or as a percent. To specify a discount, type a dash (-) before the dollar amount or percentage - for example, type -10.00 to give a discount of $10.00 to all accounts assigned to the billing group.

  4. Click Save.

To give a discount as a rate at the billing definition level, follow these steps:

  1. On the Billing menu, click Billing Definitions.

  2. In the Select a billing definition list, choose the billing definition where you want to specify the discount.

  3. On the Rates tab, type the discount amount in the Annual Rate amount box. To specify a discount, type a dash (-) before the dollar amount or percentage - for example, type -10.00 to give a discount of $10.00 to all accounts assigned to the billing group.

  4. Click Save.

How do I create an adjustment and apply a credit to a billing group or billing account?

To apply a credit to a billing group/billing account, see Create, Edit, or Delete a Billing Group Adjustment.

How do adjustments affect minimum fees?

Adjustments are deducted or added after the minimum fee is calculated.

Let's say you have the following billing situation:

Tamarac Reporting will not apply the minimum fee amount of $250 because the calculated amount of the bill is more than the minimum fee amount. Tamarac Reporting will then apply the credit amount of $60. The total calculated bill will be $210.

Can I turn off the proration of capital flows?

Yes, you can turn off prorations at the billing definition level.

To turn off proration of cash flows, follow these steps:

  1. On the Billing menu, click Billing Definitions.

  2. In the Select a billing definition list, click the billing definition where you want to turn off the proration of cash flows.

  3. On the Prorations tab, clear the Prorate capital flows check box.

  4. Click Save.

How do I set up billing periods?

To set up your billing periods, follow these steps:

  1. On the Billing menu, click Billing Groups.

  2. Click Edit next to the billing group where you want to specify the billing period. If you haven't created a billing group, visit Billing Groups.

  3. Click the Billing Periods tab and complete the following:

    Field More information

    Use billing inception date

    Select this option if you want to set the billing start date as the date that the account was created. The billing inception date is determined by the billing inception date specified in PortfolioCenter.

    Use custom billing period

    Select this option if you want to specify a custom billing date. If you select this option, choose a start date for the account by clicking in the Billing inception box and then clicking the billing start date on the calendar. If you do not complete this entry, Tamarac Reporting will set the start date as the inception date.

     

     

    You can also specify an end date for the account in the end date box. However, this an end date is not a required entry.

  4. Click Save.

How can I exclude small cash flows from billing?

To exclude small capital flows from billing, follow these steps:

  1. On the Billing menu, click Billing Definitions.

  2. In the Select a billing definition list, choose the billing definition where you want to exclude cash flows. If you haven't created a billing definition, see Create, Edit, or Delete a Billing Definition.

  3. On the Prorations tab, specify the maximum amount you want to exclude in the Exclude flows under box.

  4. Click Save.

How do I bill at a single rate?

To bill at a single rate, follow these steps:

  1. On the Billing menu, click Billing Definitions.

  2. In the Select a billing definition list, choose a billing definition. If you haven't created a billing definition, see Create, Edit, or Delete a Billing Definition.

  3. Click the Rates tab and select the Bill at single rate check box. When you select this option, Tamarac Reporting assigns one billing rate to the entire account.

    For example, you set up the following rate tiers:

    With single rate billing, a portfolio with the value of $1.5 million would be billed at a rate of .20 percent and a portfolio with the value of $5.5 million would be billed at a rate of .10 percent.

    If you do not use single rate billing, a portfolio with the value of $1.5 million would be billed like this: the first $1 million would be billed at a rate of 0.25 percent, and the remaining $500,000 would be billed at a rate of 0.20 percent.

  4. Click Save.

How do I export my management fees?

To export the data from the dynamic Billing History report:

  1. On the Billing menu, click Billing History.

  2. In the Find Data For list, start typing the number or name of the account for which you want to run the report. Click the desired record. The report appears on your screen.

  3. In the Report View list, choose a report view. If you haven't created a report view, visit Create a Billing History report view. The report appears on your screen.

  1. Click Export Data.

  1. In the File Download dialog, click Open. You can open the CSV file in Microsoft Excel or any program that is capable of opening comma-delimited files.

How can I see a report of my billing history?

The Billing History report shows the time periods, adjustments, paid amounts, and billing amounts for each portfolio. On this page you can start an auto-reconciliation, export your management fees, perform a custodian export of your billing information.

To run the dynamic billing history report, follow these steps:

  1. On the Billing menu, click Billing History.

  2. In the Find Data For list, start typing the number or name of the account for which you want to run the report. Click the desired record. The report appears on your screen.

  3. In the Report View list, choose a report view.

  1. Do any of the following:

How can I compare the previous billed amount with the current billed amount?

To compare the previous billed amount with the current billed amount, you can use an Account Billing History bulk report.

  1. Create an Account Billing History bulk report.

  2. In addition to the required columns, add:

  3. In the Set Additional Options tab, under Date period, select Most recent billing date. Most recent billing date returns the last billing history for every combination of account and billing group. This means that if an account belonged to one billing group and was subsequently moved to a different group, you will see results for both groups.

  4. Click Save.

  5. On the Accounts page, select the check box next to the account or group you want to compare.

  6. Under Actions, click Generate Bulk Report. Choose the comparison bulk report you just created and click Generate Report.

    In the output generated, you will see both the current billed amount and the previous billed amount, as well as date of previous bill.

What bifurcation dates do you use for average cost accounting?

Tamarac Reporting supports average cost accounting with the following bifurcation dates as established by IRS guidelines:

Security Type Bifurcation Date

Equities

January 1, 2011

Mutual Funds

January 1, 2011

All other security types

January 1, 2012