Page 1 of 1

Importing data file from Brightpay

Posted: 20 Apr 2020, 13:58
by Office1
Hi,

I am trying to importa a wage journal data file into Sage 50 from Brightpay. I have created a CSV file in Brightpay to include same nominal codes but I cant see the data files to match in Sage 50.


Any help would be great.

Re: Importing data file from Brightpay

Posted: 20 Apr 2020, 14:16
by brucedenney
Can you attach the file so we can see if what you have done.

Have you tried importing it?

What issues have you got?

Look at this http://import.makingithappen.co.uk/import_sage_csv.htm

Re: Importing data file from Brightpay

Posted: 20 Apr 2020, 14:34
by Office1
how do i attach the file

Re: Importing data file from Brightpay

Posted: 20 Apr 2020, 14:38
by brucedenney
Use the attachments option when you reply
Untitled.png

Re: Importing data file from Brightpay

Posted: 20 Apr 2020, 14:49
by Office1
sage journal-trial.csv

Re: Importing data file from Brightpay

Posted: 21 Apr 2020, 09:57
by brucedenney
I don't see anything obviously problematic with the data.

There seem to be a lot of entries, typically we would condense it to fewer, but it should work.

What errors are you getting when you try to import it?