Uploading creditors and debtors - spreadsheet format

Hi All

I have managed to work out the format for importing debtors and creditors into Turbocash. If you have many of these to create it might be easier to create them using a spreadsheet and then upload them rather than creating individual debtors/creditors.

Let me know if you would like a copy of the spreadsheets.

Best wishes from the UK

Alex

Views: 123

Reply to This

Replies to This Discussion

Hi Alex

I have just joined TurboCash (4.7 Build 838) to try it out and see if it will work for my needs, have started by entering some debtors then exported them, added to the resulting exported file then tried to import the csv or txt file but I get the error message "Field SACCOUNTCODE not found in import!", I would therefore greatly appreciate your spreadsheet(s) please

Thanks in Advance

Regards

Patrick

Hi Patrick

Yes I have solved this, was making up a demo file last night...

Will post it on my blog page when finished

Alex

Hi Patrick and Philip

Have just realised that I can post files here too. You can import debtors and creditors at the same time.

There are two files: an excel one with formulae to generate unique debtor and creditor codes (based on row number) and a tab separated file ready to import both debtors and creditors into Turbocash 4. The debtor account numbers start with D1 and creditors C2. You need to choose the 'tab separated' option or the import does not work.

I also noticed in doing the upload that 'separated' is spelled wrong in the import screens. It might be worth making this change in the current codebase (if not already done).

Any questions - let me know.

Alex

Attachments:
Just noticed on my mobile that the files are not visible: you might have to go on to your computer to see them.

A couple of images to help users new to this to find their way. Be sure to use Tab delimited, not comma separated.

Thanks Alex,

Will give it a try

Regards

Patrick

Al Brewer said:

Hi Patrick and Philip

Have just realised that I can post files here too. You can import debtors and creditors at the same time.

There are two files: an excel one with formulae to generate unique debtor and creditor codes (based on row number) and a tab separated file ready to import both debtors and creditors into Turbocash 4. The debtor account numbers start with D1 and creditors C2. You need to choose the 'tab separated' option or the import does not work.

I also noticed in doing the upload that 'separated' is spelled wrong in the import screens. It might be worth making this change in the current codebase (if not already done).

Any questions - let me know.

Alex

Reply to Discussion

RSS

Blog Posts

A glimpse of the future

Posted by Philip Copeman on September 7, 2017 at 15:30 0 Comments

Open source software and economic inequality

Posted by Philip Copeman on May 4, 2017 at 14:00 1 Comment

Open source software offers Governments the opportunities to build the knowledge economy and built it inclusively.

The World Economic Forum roadshow is back in town again. Economic experts on sponsored trips with generous expense accounts check into the beach front hotels amid fan fair and flashing cameras. They are offering us more advice than President Trump gets. Exotic terms like “inclusi…

Continue

There Are As Various Kinds Of Grass As Flowers

Posted by Kirsten Sue on December 19, 2016 at 17:50 0 Comments

CSA is Community Supported Agriculture, that is far more fresh produce. It is actually opportunity to participate a great environment that provides sustainably grown manufacture and to ascertain additional concerning the community and ecology that provides these merchandise for u . s citizens.

Your first phase to having an excellent six packs diet is counting your calorie absorption. You can download an excellent calorie counter on the online world. Once you do this…

Continue

TurboCASH Subscription December

Posted by Philip Copeman on December 7, 2016 at 0:04 0 Comments

If you would like to get the maximum out of TurboCASH Accounting and your Windows 10 PC, sign on for the TurboCASH 5 subscription at $60 per year. The new version makes it a whole lot easier to run a paperless office using PDF filing, Accounting Made Easy is included. Spend a few hours on improving your understanding of finance this month and start the new year with a boost.

Buy N…

Continue

Events

Videos

  • Add Videos
  • View All

© 2017   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service