Sage 50 file import

SP — Sales payment. PR — Purchase receipt. PI — Purchase Invoice. Batch PC — Purchase Credit. JC — Journal credit. JD — Journal debit. There are three ways to do this: 1. Open the program directory and in there you find a folder called Import Templates and the Audit Trial Transaction Full Template is used to import transactions into Sage Account data The templates include tips indicating the content that should be included in each column.

As in the screen below 2. Export your data and re-Import the data If you want to amend multiple fields in your records, in some modules you can export your current data , amend the required fields and then re-import the data 3. O CSV Import your data file 1.

On the menu bar click File then click Import. Note: If required, you can use the Load Map and Save Map options to import the default or previously saved mappings 9. As a workaround, on all transactions except for journals, you can import the transaction and then add the fund reference in Corrections.

They will have to be manually entered However, you can import the following foreign currency transaction types: SI — Sales invoice. SC — Sales credit. PI — Purchase invoice. PC — Purchase credit. As a workaround, you can change them to the following transaction types and allocate them manually or automatically using the allocation wizard Sales receipt, SR — import as sales payment on account, SA.

On the next window that comes up, make sure the radio button for "Accounts" is selected, fill in a name for the export file it seems to default to "Ledger Record" and type in the location i. You can also use the Browse button to navigate to your desired directory. Click Next. In the next window that comes up, first check "Include inactive accounts" if you want to do that. Most likely you don't. Then click Select All , which will put checkmarks beside all accounts, then click Next. A window will come up showing exporting progress, and finally it says "Exporting accounts completed".

Click OK to dismiss that window, then Finish on the next window. Some users of Simply Accounting use its Projects feature to track fund income and expenses.

You can actually give that feature in Simply Accounting your own name, like "Funds". However, in step 3 above, select "Projects" or whatever you have renamed it to instead of "Account", and be sure to specify a different export file name from the one you used for the Accounts. Everything else is basically the same. If you need to create sub-entities, do not select this option. Build entity for consolidated company Select to build an entity for a consolidated company during the import.

Import closing journals as transactions Select to import closing journals as transactions. This is often the sysadmin. Click OK. The data is imported to your Working Papers file. Before you can proceed, you must complete the following prerequisites: Install Pervasive SQL version v9.

Remove the read-only attribute from all files in the client data folder right-click the files, click Properties General , then deselect Read-only. To import from Sage 50 Accounting USA : Ensure you have completed all the necessary import prerequisites before you proceed.

Note that any existing prior year data will be overwritten. If you do not select this option, the current fiscal period is used. Period Balance Select to include period balances in the import, rather than year-to-date numbers. Choose your product. Get in touch. General Data Protection Regulation. Legal information. Privacy Policy. Account Settings Logout.

All Files. Submit Search. Sage Business Cloud Sage Accounting. Change product Start Payroll Billing. Import sales or purchase invoices as quick entries How to import sales and purchase transactions as quick entries or batch entries. Quick entries are invoices and credit notes that don't need to be printed.