Use the Cover Letter and Analysis features to compose letters to clients using the FCA™ Functions to dynamically merge data from the client's file into the letter. The Cover Letter feature is available to all clients on the system. Analysis is client specific.
Select Utilities>Cover Letter to create or edit a Cover Letter template. Use the formatting tools at the top of the window to format highlighted text like you would with a word processor.
Print or Preview Cover Letter
To Print or Preview from the Cover Letter Window
With the Cover Letter window open, click on the Printer icon to print it to your physical printer or click the Print Preview icon to view a preview of the letter. You may need to add the print preview icon to your toolbar, or add the Cover Letter report to the options. Click here for instructions.
To Print the Cover Letter with Other Reports
After the Cover Letter is complete, you can print the Cover Letter using the Cover Letter report in your report groups in Reports>Report List. Insert Cover Letter into the desired report group. Right-click on the desired report, select report options and enter the name of the desired letter in the Cover Letter value.
Insert Tables
You can insert a Table anywhere in the cover letter. You can use the table to align rows of data into columns, with each column having the ability to be left or right justified. This feature provides you with the ability to create Cover Letters with data in columns; however, it can be a bit difficult to work with, as the alignment of the columns is not seen on the screen. There are several reasons for this. A column which is intended to print a number with a width of a half inch requires functions which may be several screen lines in length. Another difficulty is that the grid screen table is not visible on the screen. However, by following these steps you can create reports that are nicely formatted into columns.
To Create Tables
Click on the Table icon in the Format bar.
Type in the number of columns you want to have in your Table.
Press Enter and it will expand the number of columns to that number.
Define the width of each column in inches. In the example below, the width of column one is four inches, and the width of columns two–four is one inch.
Choose either Left or Right Alignment for each column.
Click OK.
Now the Table is set at the position of your cursor. The Table begins with a preset margin of a half inch. On each row you must press Ctrl+Tab to enter the first column for that row.
Note: The cursor on the screen will only move a fraction of an inch; but when it is printed, the margin will be a half inch.
Enter the Function that you want for the first row and any variable data.
Note: Due to the length of the Functions, it is likely that one row will appear to wrap to the second row, but it will not go to the next row until you press Enter.
To move the cursor to the next column, press Ctrl+Tab.
To begin a new row, press Enter.
Click Save to save the changes.
To end a Table, click the Table icon once. To add a new Table, click the Table icon again. You can have more than one Table in a report.
Note: While you are building the report, you can click Print Preview to view it on the screen.
Functions
Most of the Functions are available for Copy and Paste (using the Windows shortcut Ctrl+C to copy and Ctrl+V to paste) within the Cover Letter by clicking on the Function button. There are eight different groups of functions: Accountant Data, Client Data 1, Client Data 2, GL Data by Class or Type 1, GL Data by Class or Type 2, GL Data by Account, Ratios, and Key Performance Indicators.
General Ledger Data By Account Classification or Type
<@F$CBALANCE(Account Class)>
GL Data by Class or Type 1
Returns Current Balance of the selected Account Classification
<@F$CACTIVITY(Account Class)>
GL Data by Class or Type 1
Returns the current period activity of the selected account classification.
<@F$YTDCACTIVITY(Account Class)>
GL Data by Class or Type 1
Returns the year-to-date activity of the selected account classification.
General Ledger Calculated Values and Ratios
<@F$CACTIVITY(Operating Income)>
GL Data by Class or Type 1
Returns the period Operating Income. (Income minus Cost minus Expense)
<@F$YTDCACTIVITY(Operating Income)>
GL Data by Class or Type 2
Returns the total year to date Operating Income through the current period.
<@F$CACTIVITY(Net Income)>
GL Data by Class or Type 1
Returns the period Net Income. (Income minus Cost minus Expense minus Other Income minus Other Expense)
<@F$YTDCACTIVITY(Net Income)>
GL Data by Class or Type 2
Returns the total year to date Net Income through the current period.
<@F$CACTIVITY(Gross Profit)>
GL Data by Class or Type 1
Returns the period Net Income. (Income minus Cost)
<@F$YTDCACTIVITY(Gross Profit)>
GL Data by Class or Type 2
Returns the total year to date Gross Profit through the current period.
General Ledger Account Data
Account Description
<AccountDescription(account lookup)>
Returns the account Description for an account Lookup. Example: <AccountDescription (102)> could return "Cash in Bank.".
Account Balance
<@F$BALANCE(account lookup)>
Returns the current amount balance of a GL account.
Example: <@F$BALANCE(103)>
Account Balance Prior Period
<@F$BALANCE(account lookup,1)>
Returns the prior amount balance of a GL account as of the end of the prior period where the number following the "," determines how many periods prior. Example: <@F$BALANCE(103,1)>
Account Quantity Balance
<@F$QTYBALANCE(account lookup)>
Returns the current quantity balance of a GL account.
Example: <@F$QTYBALANCE(103)>
Account Quantity Balance Prior Period
<@F$QTYBALANCE(account lookup,1)>
Returns the prior quantity balance of a GL account as of the end of the prior period where the number following the "," determines how many periods prior. Example: <@F$QTYBALANCE(103,1)>
Account Period Activity
<@F$ACTIVITY(account lookup)>
Returns the current period amount activity of a GL account for the current period.
Example: <@F$ACTIVITY(103)>
Account Period Prior Period Activity
<@F$ACTIVITY(account lookup,1)>
Returns the prior period amount activity of a GL account for the prior period where the number following the "," determines how many periods prior. Example: <@F$ACTIVITY(103,1)>
Account Period Quantity Activity
<@F$QTYACTIVITY(account lookup)>
Returns the current period quantity activity of a GL account.
Example: <@F$QTYACTIVITY(103)>
Account Period Quantity Prior Period Activity
<@F$QTYACTIVITY(account lookup,1)>
Returns the prior period quantity activity of a GL account for the prior period where the number following the "," determines how many periods prior. Example: <@F$QTYACTIVITY(103,1)>
Account YTD Activity
<@F$YTDACTIVITY (account lookup)>
Returns the year-to-date amount activity of a GL account.
Example: <@F$YTDACTIVITY(103)>
Account YTD Prior Period Activity
<@F$YTDACTIVITY (account lookup,1)>
Returns the year-to-date amount activity of a GL account through the end of the prior period where the number following the "," determines how many periods prior. Example: <@F$YTDACTIVITY(103,1)>
Account YTD Quantity Activity
<@F$YTDQTYACTIVITY (account lookup)>
Returns the year-to-date quantity activity of a GL account.
Example: <@F$YTDQTYACTIVITY(103)>
Account YTD Quantity Prior Period Activity
<@F$YTDQTYACTIVITY (account lookup,1)>
Returns the year-to-date quantity activity of a GL account for the prior period where the number following the "," determines how many periods prior. Example: <@F$YTDQTYACTIVITY(103,1)>
Combined Totals of Multiple GL Accounts using Wild Card Characters "%" and "_" . Use with BALANCE, ACTIVITY, and YTDACTIVITY.
<@F$BALANCE(1%)> —Returns the combined total of balances for all accounts, with Lookup codes beginning with the string of characters preceding "%" in this case "1" Use the % wild card method with all account DDLs, i.e. <@F$ACTIVITY(1%)>, etc.
<@F$ACTIVITY(3_01)> —Returns the combined total of current period activity for all accounts with Lookup codes that have a mixture of specific and wild card characters. In this case, all account codes with 4 characters beginning with 3 and ending with 01. Use the _ wild card method with all account DDLs, i.e. <@F$BALANCE(3_01)>, etc.
Define Calculated Values using *, /, +, and -.
<@F$BALANCE(103)*2> —Multiplies the balance of account 103 by 2.
<@F$YTDACTIVITY(103)/6> —Divides the year-to-date activity of account 103 by 6.
<@F$BALANCE(103)/BALANCE(901)> —Divides the balance of account 103 by the balance of account 901.
Examples of Complex Formulas to Return Data for Analysis
Sales per 1000 Gallons of Fuel <@F$ACTIVITY(408)/(QTYACTIVITY(45%)/1000)> —Returns sales per 1000 gallons of fuel for sales account 408 where all fuel Sales accounts and only fuel Sales account Lookups begin with 45.
Average Daily Sales <@F$CACTIVITY(Income)/ACTIVITY(901)> —Return average daily sales where 901 is the Statistical account for Days Open.
Average Daily Gross Profit <@F$CACTIVITY(Gross Profit)/ACTIVITY(901)> —Returns the average daily gross profit where 901 is the Statistical account for Days Open.
Define Conditional Values
Surround conditional start and end statements with "[" and "]". Use the following characters for comparison:
< is Less than
> is greater than
<= is less than or equal to
>= is greater than or equal to
! is Not
& is And
| is Or
Examples comparing Balance or Activity values:
[@CONDBALANCE(103) < 1000 & BALANCE(103)>0]Your bank balance is low.[/COND]
[@CONDBALANCE(103) < 0]Your bank balance is overdrawn.[/COND]
Examples comparing Non Balance or Activity values:
The following example is of two conditional statements back-to-back.
For clarification here, the ending and beginning brackets between the two statements are bolded.
This statement is used to keep a period from being reported as Period 13 on final year end cover letters where the Report Period has been set to 13.
We have compiled the accompanying Statement of Assets, Liabilities and Equity as of <@@Report Date> and the related Statement of Revenue and Expenses for the 1 month and [@COND<@@Report Period> < 13]<@@Report Period> [/COND][@COND<@@Report Period> = 13]12[/COND] month[@COND<@@Report Period> > 1]s[/COND] year-to-date ended <@@Report Date>, along with the enclosed supplemental information (if any), in accordance with Statements on Standards for Accounting and Review Services issued by the American Institute of Certified Public Accountants. The financial statements and supplemental information have been prepared on the accounting basis used by the company for Federal income tax purposes, which is a comprehensive basis of accounting other than generally accepted accounting principles.
A Compilation is limited to presenting, in the form of financial statements, information that is the representation of management. We have not audited or reviewed the accompanying financial statements and supplemental information and, accordingly, do not express an opinion or any other form of assurance on them.
Management has elected to omit substantially all of the disclosures ordinarily included in financial statements prepared on the income tax basis of accounting. If the omitted disclosures were included in the financial statements and supplemental information, they might influence the user's conclusions about the Company's assets, liabilities, equity, revenues, and expenses. Accordingly, these statements are not designed for those who are not informed about such matters.
<@SysAccountant DBA>
Stop copying here.
Generic Compilation Report for the current year-to-date only.
Copy everything between this box, and the next one.
We have compiled the accompanying Statement of Assets, Liabilities and Equity as of <@@Report Date> and the related Statement of Revenue and Expenses for the 1 month and [@COND<@@Report Period> < 13]<@@Report Period> [/COND][@COND<@@Report Period> = 13]12[/COND] month[@COND<@@Report Period> > 1]s[/COND] year-to-date ended <@@Report Date>, along with the enclosed supplemental information (if any), in accordance with Statements on Standards for Accounting and Review Services issued by the American Institute of Certified Public Accountants. The financial statements and supplemental information have been prepared on the accounting basis used by the company for Federal income tax purposes, which is a comprehensive basis of accounting other than generally accepted accounting principles.
A Compilation is limited to presenting, in the form of financial statements, information that is the representation of management. We have not audited or reviewed the accompanying financial statements and supplemental information and, accordingly, do not express an opinion or any other form of assurance on them.
Management has elected to omit substantially all of the disclosures ordinarily included in financial statements prepared on the income tax basis of accounting. If the omitted disclosures were included in the financial statements and supplemental information, they might influence the user's conclusions about the Company's assets, liabilities, equity, revenues, and expenses. Accordingly, these statements are not designed for those who are not informed about such matters.
<@SysAccountant DBA>
Stop copying here.
Generic Compilation Report for a year-to-date comparison to last year.
Copy everything between this box, and the next one.
We have compiled the accompanying Statement of Assets, Liabilities and Equity as of <@@Report Date> and <@@Report Date Prior Year> and the related Statement(s) of Revenue and Expenses for the years ended <@@Report Date> and <@@Report Date Prior Year> along with the enclosed supplemental information (if any), in accordance with Statements on Standards for Accounting and Review Services issued by the American Institute of Certified Public Accountants. The financial statements and supplemental information have been prepared on the accounting basis used by the company for Federal income tax purposes, which is a comprehensive basis of accounting other than generally accepted accounting principles.
A Compilation is limited to presenting, in the form of financial statements, information that is the representation of management. We have not audited or reviewed the accompanying financial statements and supplemental information and, accordingly, do not express an opinion or any other form of assurance on them.
Management has elected to omit substantially all of the disclosures ordinarily included in financial statements prepared on the income tax basis of accounting. If the omitted disclosures were included in the financial statements and supplemental information, they might influence the user's conclusions about the Company's assets, liabilities, equity, revenues, and expenses. Accordingly, these statements are not designed for those who are not informed about such matters.
<@SysAccountant DBA>
Stop copying here.
Compilation report for a tax basis statement for a Corp, S-Corp, or LLC.
Copy everything between this box, and the next one.
Management is responsible for the accompanying financial statements of <@@Company Name>[@COND<@@Company Phone 2> > 0], d/b/a <@@Company DBA>[/COND], which comprise the statement of assets, liabilities, and equity (income tax basis) as of <@@Report Date Alpha>, and the related statements of revenues and expenses (income tax basis), and changes in equity (income tax basis) for the 1 <@@Period Type Alpha> and <@@Report Period> <@@Period Type Alpha>[@COND<@@Report Period> > 1]s[/COND] then ended, in accordance with the tax basis of accounting and for determining that the tax basis of accounting is an acceptable financial reporting framework. I have performed a compilation engagement in accordance with Statements on Standards for Accounting and Review Services promulgated by the Accounting and Review Services Committee of the AICPA. I did not audit or review the financial statements nor was I required to perform any procedures to verify the accuracy or completeness of the information provided by management. Accordingly, I do not express an opinion, a conclusion, nor provide any form of assurance on these financial statements.
The financial statements are prepared in accordance with the tax basis of accounting, which is a basis of accounting other than accounting principles generally accepted in the United States of America.
Management has elected to omit substantially all of the disclosures ordinarily included in financial statements prepared in accordance with the tax basis of accounting. If the omitted disclosures were included in the financial statements, they might influence the user’s conclusions about the Company’s assets, liabilities, equity, revenues, and expenses. Accordingly, the financial statements are not designed for those who are not informed about such matters.
Supplemental information, if attached, is presented for purposes of additional analysis and is not a required part of the basic financial statements. The information is the representation of management. I have not audited, reviewed, or performed a compilation engagement on the information and, accordingly, I do not express an opinion, a conclusion, nor provide any assurance on it.
I am not independent with respect to <@@Company Name>[@COND<@@Company Phone 2> > 0], d/b/a <@@Company DBA>[/COND].
<@SysAccountant Name>
<@SysAccountant City>, <@SysAccountant State>
<Date>
Stop copying here.
Compilation report for a tax basis statement for a Not For Profit.
Copy everything between this box, and the next one.
Management is responsible for the accompanying financial statements of <@@Company Name>[@COND<@@Company Phone 2> > 0], d/b/a <@@Company DBA>[/COND], which comprise the statement of assets, liabilities, and fund balances (income tax basis) as of <@@Report Date Alpha>, and the related statements of revenues and expenses (income tax basis), and changes in fund balances (income tax basis) for the 1 <@@Period Type Alpha> and <@@Report Period> <@@Period Type Alpha>[@COND<@@Report Period> > 1]s[/COND] then ended, in accordance with the tax basis of accounting and for determining that the tax basis of accounting is an acceptable financial reporting framework. I have performed a compilation engagement in accordance with Statements on Standards for Accounting and Review Services promulgated by the Accounting and Review Services Committee of the AICPA. I did not audit or review the financial statements nor was I required to perform any procedures to verify the accuracy or completeness of the information provided by management. Accordingly, I do not express an opinion, a conclusion, nor provide any form of assurance on these financial statements.
The financial statements are prepared in accordance with the tax basis of accounting, which is a basis of accounting other than accounting principles generally accepted in the United States of America.
Management has elected to omit substantially all of the disclosures ordinarily included in financial statements prepared in accordance with the tax basis of accounting. If the omitted disclosures were included in the financial statements, they might influence the user’s conclusions about the Company’s assets, liabilities, equity, revenues, and expenses. Accordingly, the financial statements are not designed for those who are not informed about such matters.
Supplemental information, if attached, is presented for purposes of additional analysis and is not a required part of the basic financial statements. The information is the representation of management. I have not audited, reviewed, or performed a compilation engagement on the information and, accordingly, I do not express an opinion, a conclusion, nor provide any assurance on it.
I am not independent with respect to <@@Company Name>[@COND<@@Company Phone 2> > 0], d/b/a <@@Company DBA>[/COND].
<@SysAccountant Name>
<@SysAccountant City>, <@SysAccountant State>
<Date>
Stop copying here.
Compilation report for a tax basis statement for a Partnership or Sole Proprietor.
Copy everything between this box, and the next one.
Management is responsible for the accompanying financial statements of <@@Company Name>[@COND<@@Company Phone 2> > 0], d/b/a <@@Company DBA>[/COND], which comprise the statement of assets, liabilities, and capital (income tax basis) as of <@@Report Date Alpha>, and the related statements of revenues and expenses (income tax basis), and capital (income tax basis) for the 1 <@@Period Type Alpha> and <@@Report Period> <@@Period Type Alpha>[@COND<@@Report Period> > 1]s[/COND] then ended, in accordance with the tax basis of accounting and for determining that the tax basis of accounting is an acceptable financial reporting framework. I have performed a compilation engagement in accordance with Statements on Standards for Accounting and Review Services promulgated by the Accounting and Review Services Committee of the AICPA. I did not audit or review the financial statements nor was I required to perform any procedures to verify the accuracy or completeness of the information provided by management. Accordingly, I do not express an opinion, a conclusion, nor provide any form of assurance on these financial statements.
The financial statements are prepared in accordance with the tax basis of accounting, which is a basis of accounting other than accounting principles generally accepted in the United States of America.
Management has elected to omit substantially all of the disclosures ordinarily included in financial statements prepared in accordance with the tax basis of accounting. If the omitted disclosures were included in the financial statements, they might influence the user’s conclusions about the Company’s assets, liabilities, capital, revenues, and expenses. Accordingly, the financial statements are not designed for those who are not informed about such matters.
Supplemental information, if attached, is presented for purposes of additional analysis and is not a required part of the basic financial statements. The information is the representation of management. I have not audited, reviewed, or performed a compilation engagement on the information and, accordingly, I do not express an opinion, a conclusion, nor provide any assurance on it.
I am not independent with respect to <@@Company Name>[@COND<@@Company Phone 2> > 0], d/b/a <@@Company DBA>[/COND].
<@SysAccountant Name>
<@SysAccountant City>, <@SysAccountant State>
<Date>
Stop copying here.
Compilation report for an accrual basis statement for a Corp, S-Corp or LLC.
Copy everything between this box, and the next one.
Management is responsible for the accompanying financial statements of <@@Company Name> [@COND<@@Company Phone 2> > 0], <@@Company DBA>[/COND], which comprise the balance sheet as of <@@Report Date Alpha>, and the related statement of income for the 1 <@@Period Type Alpha> and <@@Report Period> <@@Period Type Alpha>[@COND<@@Report Period> > 1]s[/COND] then ended in accordance with accounting principles generally accepted in the United States of America. I have performed a compilation engagement in accordance with Statements on Standards for Accounting and Review Services promulgated by the Accounting and Review Services Committee of the AICPA. I did not audit or review the financial statements nor was I required to perform any procedures to verify the accuracy or completeness of the information provided by management. Accordingly, I do not express an opinion, a conclusion, nor provide any form of assurance on these financial statements.
Management has elected to omit substantially all of the disclosures and the statement of cash flows required by accounting principles generally accepted in the United States of America. If the omitted disclosures and statement of cash flows were included in the financial statements, they might influence the user's conclusions about the Company's financial position, results of operations, and cash flows. Accordingly, the financial statements are not designed for those who are not informed about such matters.
Supplemental information, if attached, is presented for purposes of additional analysis and is not a required part of the basic financial statements. The information is the representation of management. I have not audited, reviewed, nor performed a compilation engagement on the information and, accordingly, I do not express an opinion, a conclusion, nor provide any assurance on it.
I am not independent with respect to <@@Company Name>[@COND<@@Company Phone 2> > 0], <@@Company DBA>[/COND].
Comments
0 comments
Article is closed for comments.