Exporting and Importing Financial Statement Layouts

Home | News & Updates | Sage tip of the week | Exporting and Importing Financial Statement Layouts

Do you have a new company set up in your system, but there is no Profit and Loss or Balance Sheet format set up?

Well Exporting and Importing Financial Statement Layouts will make the formats easier to create.

If you have an existing company on your Sage system that has the same nominal structure, you can copy the layouts from that company to the new one. By exporting and importing financial statement layouts you then don’t have to go through the time-consuming effort of recreating them from scratch.


From company with the existing layouts, go to the ‘Financial Statement Layouts’ window pick either profit and loss or balance sheet, highlight the report and click export.

Save the file as a .csv somewhere easy to find.

Go to the sage company that you would like to import them into and back into the ‘Financial Statement Layouts’ window. Pick the sort the you would like to import and click import.

Select the .csv file that you saved earlier, click open.

Click save and close

The imported layout will then be save. I would always recommend then click ‘validate’ as this will check whether there are any nominals missing from the report.

You can then over type the name of the report if you don’t want it to be called ‘Imported Layout’

You can have multiple financial layouts and you get the choice which one to run in the criteria window, so whatever you name it in the above window will appear as a selection here


If you would like to stay in the loop about our latest tip then make sure you are following us on TwitterLinkedIn and Facebook!

As we are constantly looking at ways in which we can improve our service, you are more than welcome to leave your feedback on our form. If you have any suggestions for what you would like to see featured as a tip of the week please email sagemarketing@smithcooper.co.uk.

If you would like more support concerning your Sage system, take a look at our Sage support service. Contact us via the enquiry forms or call 01332 587 515 if you would like more information.


NB: Be advised that the information/accuracy in this article may differ depending on which version of Sage 200 you use, as a result, some options and processes might look different. For all support queries please email sagesupport@smithcooper.co.uk.

Interested to know more about our Sage solutions?

Call 01332 587515 or enquire online today