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
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 firstname.lastname@example.org.
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 email@example.com.