Exporting Financial Statements to Excel merges columns
Description
Cause
Resolution
[BCB:5:Third-party support:ECB]


Use the following solution to modify your General Ledger financial statement so that the columns export successfully into Excel. When exporting canned Financial Statements, without modifications the data columns merge or totals end up in the wrong columns.

  1. Make a copy of the design:
    1. In Financial Statement Designer, from the File menu, select Open.
    2. Select the design that you want to print as an .xls file type and then click Open.
    3. From the File menu, select Save as, type a unique name for this design, such as "TBalAccr_ExportExcel" and then click Save.
  2. Remove page breaks from the Financial Statement design:
    1. Select the first page break.
    2. From the Edit menu, select Delete Instruction, and then click Yes.
    3. Repeat for any additional page breaks.
  3. Modify the Header:
    1. From the View menu, select Header.
    2. Select the first row and from the Edit menu, select Delete Instruction. Click Yes.
    3. Repeat Step 3.2 for any additional rows until the header is blank.
  4. Modify the Footer:
    1. From the View menu, select Footer.
    2. Select the first row and from the Edit menu, select Delete Instruction. Click Yes.
    3. Repeat Step 4.2 for any additional rows until the footer is blank.
  5. Modify the Body (optional):
    1. From the View menu, select Body.
    2. Select the top row, then from the Design menu, select Insert, Blank.
    3. Repeat Step 5.2 three more times, then select the first row.
    4. From the Design menu, select Text Field.
    5. In the Text Field window, select Company Name, and click on OK.
    6. With the first row still selected, from the Design menu, select Instruction Options.
    7. In the Justification section, select Centered on Page and click OK.
    8. Select the second row.
    9. Type the name of the statement (e.g. "Trial Balance").
    10. With the second row still selected, from the Design menu, select Instruction Options.
    11. In the Justification section, select Centered on Page and click OK.
    12. Select the third row.
    13. From the Design menu, select Text Field.
    14. In the Text Field window, select Period Ending Date, and click on OK.
    15. With the third row still selected, from the Design menu, select Instruction Options.
    16. In the Justification section, select Centered on Page and click OK.
  6. Format the Columns:
    1. Select the row containing your column headings and from the Design menu, select Instruction Options.
    2. Starting with first amount column (click the < and > buttons at the bottom of the window to move between columns)
      • Under Print Symbols, select No symbols.
      • Increase the Width a small amount (e.g. from 1.50 to 2.00).
      • You may also need to increase the Start value to increase the space between columns.
      • You may need to change the column Heading text to be on one line instead of multiple lines. Consider abbreviating the text to fit on one line.
    3. Repeat step 6.2 for each column.
  7. Change the Design Options:
    1. From the Design menu, select Design Options.
    2. On the General tab, unmark Repeat column headings.
    3. On the Amount tab, change the Print abnormal sign as to -# and unmark Print commas.
    4. Click OK.
  8. Save the design changes. From the File menu, select Save.

Note: Exporting financial statements to Excel can cause lines to be deleted. Verify after exportation.

To export the financial statement to Excel, refer to How do I save a report as an Excel spreadsheet?

Steps to duplicate
Related Solutions