Creating and Editing Billing Forms

forms and scenarios, see https://schwabpt.com/support/learn/billing.htm . Creating and Editing Billing Forms Page 2 of 10 To edit an existing form: Time Saver Tips It is a good idea to: 1.<br><br> Select a pre-loaded form to start, and then customize it as needed. PortfolioCenter comes pre- loaded with several forms, or you can select a form from our website at https://schwabpt.com/support/learn/billing.htm . Also, for additional information and tips for editing forms, see https://schwabpt.com/pdflibrary/open.asp?id=010693 .<br><br> 2. Decide on the font style and size for the billing statement you want to send to clients. For example, Times New Roman, size 11.<br><br> 3. Set the font style and size. Select any portfolio, click the Reports button, select the Billing Statement report, and then click the settings button.<br><br> The font style and size settings are toward the bottom. 4. Use a sample portfolio (or portfolios) to run statements for as you edit the billing form.<br><br> This way, you can check your work as you are creating the statement, instead of after you print all the statements. It is a good idea to work with one small and one large portfolio so you can align everything to fit both portfolios. 5.<br><br> If you are setting up a billing form for the first time, be sure to assign that billing form to the sample portfolios to do your testing. For more information about how to assign a billing form, see https://schwabpt.com/pdflibrary/open.asp?id=010686 . 1 Click the Billing tab.<br><br> 2 Click the Forms button on the left. 3 Select the form you want to update, and then click the Go to Details button. 4 Edit the form, as needed, using the merge fields, field formatting codes, line formatting codes in this document, and any additional text, as needed.<br><br> 5 Click the Save button to save the changes. 6 Run a sample billing statement to check for spacing. 7 Continue editing, or repeat steps 4 through 6, until you are sure the statement appears the way you want it to appear.<br><br> 8 Assign the form to any portfolios for which you are printing statements, but do not yet have a form assigned. 9 Batch print a larger sample of billing statements to PDF to check for spacing on a larger sample before printing them to paper. For more information about batch printing to a PDF file, see https://schwabpt.com/pdflibrary/open.asp?id=010173 .<br><br> Creating and Editing Billing Forms Page 3 of 10 Merge Fields Merge fields pull information from the PortfolioCenter database, like names and addresses, to help you create customized billing forms without having to create them for each portfolio individually. Merge field are set apart from static text by asterisks (*) before and after. When the billing statement is generated, the vale for each merge field is inserted into the billing form beginning at the location of the left asterisk.<br><br> The merge fields are not case sensitive. The fields are listed in alphabetical order by merge field name. Note When the letter n is the last letter of a merge field (as in *feeamtn*), it is not a variable and should not be replaced by some other value.<br><br> Merge Field Description *accttype* Client account type *acctnum* Client account number *address2* through *address6* Client street address *advisor1* through *advisor7* Advisor details, line 1 through line 7 *advisordesc* Advisor description *advisorID* Short, identifying code for the advisor *afterdisc* Total fee after adjustments for capital flows and discounted rate, but before adjustments for minimum fee, inception proration or miscellaneous adjustment *afterincept* Total fee after adjustments for capital flows, minimum fee, and inception proration, but before the miscellaneous adjustment *aftermin* Total fee after adjustments for capital flows and minimum fee, but before adjustments for inception proration or miscellaneous adjustment *aftermisc* The pre-tax amount of the bill *afterpro* Total fee after adjustments for capital flows, but before adjustments for minimum fee, inception proration, or miscellaneous adjustment *begdate* Billing period beginning date *begprice* Billing period beginning price *begvalue* Billable portfolio value at beginning of billing cycle (*begdate*) *begyear* Beginning date year. For example: 2006 *billacct* Billing account number *billdays* Number of days in billing period. *billdesc* Billing spec description *cattitle* Category title *city* Client city *ctystzip* Client city, state and zip code *company* Client company name Creating and Editing Billing Forms Page 4 of 10 Merge Field Description *default1* First line of the client name and address, as printed on PortfolioCenter reports *default2* Second line of client name and address as printed on PortfolioCenter reports *descriptn* Description for the billing range *discamt* Computed discount amount based on the discount rate for the portfolio *discrate* Discount rate assigned to the portfolio on the Settings tab of the portfolio details *%discrate* Discount rate assigned to the portfolio on the Settings tab of the portfolio details, expressed as a percentage *endvalue* Billable portfolio value at the end of the billing cycle (*enddate*) *enddate* Billing period ending date *endprice* Billing period ending price *endyear* Ending date year.<br><br> Example: 2006 *fax* Client fax number *feeamtn* Fee amount computed for the billing period *firstname* Client first name *flowamtn* Amount of each capital flow during the billing period. If there is more than one flow, the information is repeated. You only need to use this field once.<br><br> *flowdaten* Date of each capital flow during the billing period. If there is more than one flow, the information is repeated. You only need to use this field once.<br><br> *fromvaln* Lower value of the billing range *gacctnum* Group account number *gaccttype* Group account type *gaddress1* through *gaddress6* Group street address *gadvisor1* through *gadvisor7* Group advisor details, line 1 through line 7 *gadvisordesc* Group advisor description *gadvisorid* Short, identifying code for the advisor assigned to the group. *gbegvalue* Group billable portfolio value at the beginning of the billing cycle (*begdate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio.<br><br> *gbillacct* Billing account number of the group assigned to the portfolio for which the statement is run. *gcity* Group city *gctystzip* Group city, state and zip *gcompany* Group company name *gdiscrate* Discount rate assigned to the group, displayed on the statement as a percentage *gendvalue* Group billable portfolio value at then end of the billing cycle (*enddate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio.<br><br> Creating and Editing Billing Forms Page 5 of 10 Merge Field Description *gfax* Group fax number *gfirstname* Group first name *ggrossfee* Group total fee before any adjustments for withdrawals and deposits, minimum fee, inception proration or miscellaneous adjustment. Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio. *glastname* Group last name *gmodelname* Name of the model assigned to the group *gnbegvalue* Group non-billable portfolio value at the beginning of the billing cycle (*begdate*).<br><br> Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio. *gnendvalue* Group non-billable portfolio value at the end of the billing cycle (*enddate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio.<br><br> *gobjective* Group account objective *gperfinceptdate* Group performance inception date. PortfolioCenter looks at the performance inception date of all group members and displays the earliest. *gphone* Group phone number *grossfee* Total fee before any adjustments for capital flows, minimum fee, inception proration, or miscellaneous adjustment.<br><br> *gssnum* Group social security number or tax ID number *gstate* Group state *gstreet* Group street *gtbegvalue* Group total portfolio value (billable plus non-billable) at the beginning of billing cycle (*begdate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio. *gtendvalue* Group total portfolio value (billable plus non-billable) at the end of the billing cycle (*enddate*).<br><br> Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio. *gzipcode* Group zip code *ibegvalue* Individual billable portfolio value at beginning of the billing cycle (*begdate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio.<br><br> *iendvalue* Individual billable portfolio value at end of the billing cycle (*enddate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio. *inbegvalue* Individual non-billable portfolio value at the beginning of the billing cycle (*begdate*).<br><br> Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio. *inendvalue* Individual non-billable portfolio value at the end of the billing cycle (*enddate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio.<br><br> Creating and Editing Billing Forms Page 6 of 10 Merge Field Description *incept* Billing inception date *inceptamt* Amount of adjustment for the period prior to the portfolio inception. For example, if the portfolio 9s billing inception date occurs in the middle of the billing period and you are prorating the fee for only the amount of time the portfolio was under management, this field displays the adjustment for the number of days between the beginning of the billing cycle and the billing inception date. *incptdays* Days from the beginning date to the inception date.<br><br> For example, if the portfolio 9s billing inception date occurs in the middle of the billing period and you are prorating the fee for only the amount of time the portfolio was under management, this field displays the number of days between the beginning of the billing cycle and the billing inception date. *itbegvalue* Individual total portfolio value (billable plus non-billable) at the beginning of the billing cycle (*begdate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio.<br><br> *itendvalue* Individual total portfolio value (billable plus non-billable) at the end of the billing cycle (*enddate*). Use this merge field only if you are computing the fee based on an aggregate group value, but producing a statement for an individual portfolio. *lastdescriptn* Description for final range *lastname* Client last name *mindesc* Minimum fee description *minfee* Minimum fee amount *miscamt* Miscellaneous adjustment amount *miscdesc* Miscellaneous adjustment description *modelname* Name of the model assigned to the portfolio or group *modeltitle* Descriptive title of the model *nbegvalue* Non-billable beginning value *nendvalue* Non-billable ending value *objective* Client account objective *pacctn* Account number of the individual portfolio when allocating fees to group members.<br><br> *pbillacctn* Billing account number for an individual portfolio in a group when the bill amount is allocated to group members. *pbillamtn* Fee amount assigned to an individual portfolio in a group when the bill amount is allocated to group members. *perfincetpdate* Performance inception date.<br><br> *phone* Client phone number *pnamen* Name of the individual portfolio when allocating fees to group members. Creating and Editing Billing Forms Page 7 of 10 Merge Field Description *proamtn* Adjustment computed for the capital flow. If there is more than one flow, the information is repeated.<br><br> You only need to use this field once. *prodays* The number of days used to calculate the proration amount. If billing in arrears, *prodays* is the number of days before inflows, and the number of days after outflows.<br><br> If billing in advance, the opposite is true since you are prorating for a previous period: *prodays* is the number of days after inflows, and the number of days before outflows. *proratan* Number of days from the beginning date to the flow date (*flowdaten*). *proraten* Billing rate used to create the prorated adjustment for each flow, displayed on a billing statement in decimal format.<br><br> *%proraten* Billing rate used to create the prorated adjustment for each flow, displayed on a billing statement in percentage format. *prototal* Total adjustment for all capital flows. *pvaluen* Value of the individual portfolio in a group when the bill amount is allocated to group members.<br><br> *rangeamtn* Total dollar value of the billing rate range. For example, from $0.00 to $100,000.00. The value that appears here depends on where in the rate schedule, as set up in the billing spec.<br><br> If the portfolio value falls into multiple tiers, each tier is listed without repeating the merge field (you only need to add the field once). *raten* Rate applied to the portfolio or category for the billing period. The rate applied depends on where the portfolio or group value falls in the rate schedule.<br><br> *%raten* Rate applied to the portfolio or category for the billing period, as expressed in a percentage. The rate applied depends on where the portfolio or group value falls in the rate schedule. *ssnum* Client social security number *state* Client state *street* Client street address *taxamt* The amount of the service tax *taxrate* The service or sales tax rate displayed on the statement in decimal format.<br><br> *%taxrate* The service or sales tax rate displayed on the statement in percentage format. *tbegvalue* Total beginning portfolio value, billable and non-billable *tendvalue* Total ending portfolio value, billable and non-billable *today* System date at the time the page is generated *totadds* Total additions (deposits and receipts) to the account during the billing period *totamt* Total fee after all adjustments *totflows* Total net capital flows 3 net of (deposits + receipts) 3 (withdrawals + transfers) *totwith* Total withdrawals (withdrawals and transfers) from the account during the billing period *tovaln* Upper value of billing range *zipcode* Client zip code Creating and Editing Billing Forms Page 8 of 10 Field Formatting Codes Field format codes control the formatting of individual merge fields. The field format codes must be placed at the end of a merge field.<br><br> The table below shows the codes in order of the type of parameter. Parameter Code(s) Description Bold Merge Field Text .B Use this code to bold a single field. For example, *pacctn.B*.<br><br> Dates .Dn, where n is a date format code. Use this code to print dates in a variety of formats: .D0 MM/DD/YY, as in 04/02/06. .D1 MM/DD/YYYY, as in 04/02/2006 (the default) .D2 M/D/YY, as in 4/2/06 .D3 M/D/YYYY, as in 4/2/2006 .D4 MM-DD-YY, as in 04-02-06 .D5 MM-DD-YYYY as in 04-02-2006 .D6 M-D-YY, as in 4-2-06 .D7 M-D-YYYY, as in 4-2-2006 .D8 Mon D, YYYY, as in Apr 2, 2006 .D9 Month D, YYYY, as in April 2, 2006 Dollar Sign .$ Use to print money fields with a dollar sign.<br><br> For example, *fromvaln.$* will appear as $5000.00. Field Length :N, where N is a number. For example: *proamtn:10* defines the field as only 10 characters wide.<br><br> Use this code to reserve space for or limit the space occupied by a merge field. Replace :N with the actual length to be printed. This code can be used with other field codes, and it can be placed before or after the other codes.<br><br> Justification .L and .R Use these codes to align text in columns on the billing statement. To create columns, use these codes in conjunction with the field length code above. When using the left justify format, if the value is longer than the space between the two asterisks, it is truncated on the right.<br><br> When using the right justify format, if the value is longer than the indicated length, it is truncated on the left. Proportional font .T Use this code to collapse the text for variable length merge fields so that fixed spaces are not reserved for text merge fields. For example: Field: *Perfincetpiondate.D9* Result Performance measured from March 31, 2006 Field: *perfinceptiondate.D9.T* Result: Performance measured from March 31, 2006 Rounding .O Use to round amounts to the nearest dollar on the billing statement, but store the actual value in the billing history.<br><br> To store the final billing amount to the rounded number in billing history, enable the setting on the billing spec. Creating and Editing Billing Forms Page 9 of 10 Line Formatting Codes Line formatting codes control the printing of entire lines of text and/or merge fields. Follow these tips for more successful use of the line formatting codes: f You must place the line format codes at the beginning of a line.<br><br> f You can use more than one code, but do not put spaces between them. For example, if you want to bold and highlight text on a line, use %B%H, no spaces. Tips Use line format codes can also be used to create conditional blank lines before and after special lines.<br><br> For example, to add a blank line before and after the minimum fee amount, add %M on the line before and %M on the line after the minimum fee line, as shown above. If the minimum fee applies, the extra lines are added. If the minimum fee does not apply, the extra space is not added to the statement.<br><br> The following codes are in alphabetical order by code. Line Code Description %A Print the line only if a miscellaneous adjustment is used %B Bold the text of the line %C Center the text of the line %D Print the line only if a discount rate is used %G Print the line with *grossfee* only if more than one breakpoint is used in calculating the fee at the portfolio or category level. %H Highlight the line with shading %I Print the line only if the fee is prorated for a new account and the billing inception date falls within the billing period.<br><br> %L Print the line only if the group bill is allocated to individual portfolios %LOGONAME Prints an advisor logo, if you have one. The merge entire line should be: %LOGONAME. L : bitmapname.bmp , where L is the justification (L for left, R for right or C for Center) and bitmapname is the name of the bitmap file.<br><br> For example, if you want to put your logo named cadvisorlogo.bmp d on the center of the billing statement, the entire code would be: %LOGONAME.C:advisorlogo.bmp On the Web For more information about using advisor logos, see https://schwabpt.com/pdflibrary/open.asp?id=010598 %M Print the line only if a minimum fee applies %NEWPAGE Start a new page %P Print the line only if prorations for cash flows exist %T Print the line only if the service tax is not zero %X Print the line only if the portfolio or group has assets excluded from billing. Creating and Editing Billing Forms Page 10 of 10 Straight Text You might want to add static text in addition to merge fields on your Billing Statement. For example, you can add a note at the bottom that tells clients the fee has been deducted from their account and who to contact for more information.<br><br> You can add text easily by editing the billing form you are using. 1 Click the Billing tab. 2 Click the Forms button on the left.<br><br> 3 Select the form you want to update, and then click the Go to Details button. 4 Type text directly into the billing form. You can also copy and paste test from another source into the billing form.<br><br> Tips f Remember: type text around the merge fields. f You only have so much room on a line 3 be mindful of the amount of space you have available. It might be a good idea to select the font style and size before editing the billing form so you can test the spacing as you edit the form.<br><br> f Refer to the Line Formatting Codes section above for information about conditional information 3 or lines that only appear when the condition applies. Be careful about adding text to conditional lines. Only add text if you want it to only appear in certain situations.<br><br> 5 Click the Save button to save the changes.

less