Forum Message

CSV Import. Connecting PO with certain accounts.

I have copied all the fields under the part of the help file listed:
Invoice, Credit Note, Quote and Purchase Order Format

Seems to import fine but I wondered how I tie it up to a certain account such as Advertising and Entertainment and make it debit that account to show it as an expense.

Can you tell me the extra fields I need to add. I am a bit thick when it comes to accounts so I am struggling to work it out.

Thank you in advance and apologies for taking up your time.


Posted by Michael Bull on Nov 25, 2009 4:16 PM GMT

Hi Michael,

Just enter 'Advertising and Entertainment' in the 'Line 1 Account' column for your Purchase Invoice. This will then debit the account by the amount you enter under 'Line 1 Amount'.

Note also that for simple expenses where your supplier doesn't offer credit, it's simpler to record the expense as a 'Money Paid Out' transaction (rather than a Purchase Invoice). See the top of this page for an example:
http://www.solaraccounts.co.uk/help/how-to-import-data-from-csv-file.php

Cheers,


Posted by Mark McLaren (Solar Accounts) on Nov 25, 2009 4:59 PM GMT

Should have also emphasised that the Type needs to be Purchase Invoice (because Purchase Orders have no effect on the account balancess)


Posted by Mark McLaren (Solar Accounts) on Nov 25, 2009 5:01 PM GMT