Import AR and AP transactions

You can import AR and AP transactions. For AR Transactions, format your data using the following sample: invnumber,customernumber,transdate,amount,description,notes,source,memo 00003,AE001,10-11-07,2030,”desc1″,”notes1″,”source1″,”memo1″ 00004,CP002,07-12-07,3213,”desc1″,”notes2″,”source2″,”memo2″ 00005,SP007,09-12-07,-200,”desc1″,”notes3″,”source3″,”memo3″ For AP transactions, format your data using the following example: invnumber,vendornumber,transdate,amount,description,notes,source,memo 00003,CB001,10-10-08,2030,”desc1″,”notes1″,”source1″,”memo1″ 00004,ES002,10-12-08,3213,”desc2″,”notes2″,”source2″,”memo2″ 00005,SA003,12-12-08,-200,”desc3″,”notes3″,”source3″,”memo3″

Import Chart of Accounts

Follow these steps to import your chart of accounts from legacy accounting software into sql-ledger. Export/prepare your chart of accounts in your spreadsheet software according to the sample given below. Double check the correctness of your final csv file by opening it in a text editor like notepad or wordpad. Upload the chart csv file […]

Import Customers and Vendors

To import customers, create/prepare a CSV file using the following sample as template. customernumber,name,firstname,lastname,contacttitle,phone,fax,email,notes,address1,address2,city,state,zipcode,country 001,Ledger123,Armaghan,Saqib,Consultant,,,saqib@ledger123.com,”These are, just, sample notes”,,,London,,”AA7 8BB”,UK Vendors can be important in similar way. Change “customernumber” to “vendornumber” for vendors import.

Import customer price list

Format your customer price list according to the sample CSV data below. partnumber,customernumber,pricegroup,pricebreak,sellprice,validfrom,validto,curr B001,AE001,PG1,10,11,03-01-2008,,GBP B002,BP011,,20,12,,03-01-2009,GBP M004,CP002,,15,20,03-01-2008,03-05-2008,GBP D08,CP002,test,25,25,,,GBP Click ‘Data Import–Parts Customers’, specify the file with the ‘Browse’ button and click ‘Import Parts Customers’ button. Following page will be displayed. Here you can un-check the rows which you do not want to import. Rows with invalid […]

Import vendor price list

Format your vendors price list according to the sample CSV data below: partnumber,vendornumber,vendorpartnumber,lastcost,curr,leadtime B001,CB001,V-CB001,10,GBP,15 B002,ES002,,14,GBP,45 M004,SA003,,21,GBP,30 Click ‘Data Import–Parts Vendors’, specify the file with the ‘Browse’ button and click ‘Import Parts Vendors’ button. Following page will be displayed. Here you can un-check the rows which you do not want to import. Rows with invalid vendor […]