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: 57

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

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

How Trump beat his taxes.

Posted by Philip Copeman on November 15, 2016 at 11:30 4 Comments

 Unless you have been under a rock for the last 6 months, you must have followed how President Elect Donald Trump avoided income tax over the last few years. He did this by using Depreciation!

Its all legal of course and most Governments offer you this…

Continue

Interesting Facts About Reviews of Essay Writing Service

Posted by JamesDegarmo on November 2, 2016 at 12:05 0 Comments

An essay paper is an impression of one's identity. It gives a knowledge into an individual's capacity to express. It gives the readers a thought regarding the individual's disposition, inclination and vision. The knowledge about essay composition is an important parameter as it measures the understanding levels of the writer; more so in case of based on fact topics. There are several professional writers and their explanation…

Continue

Events

Videos

  • Add Videos
  • View All

© 2017   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service