Page 1 of 1
Uploading from excel to sage 50 jnls
Posted: 02 Jun 2020, 14:56
by gerryturley
Help please
We are a charity and the standard templates to upload jnls does not works as we use fund account. My plan is to use to upload from a spreadsheet to a standard jnl. Is there a script that I could you upload from a spreadsheet to the standard jnl layout.
Re: Uploading from excel to sage 50 jnls
Posted: 03 Jun 2020, 10:55
by brucedenney
The sage import routines do not support importing audit transactions with funds so you can't do that!.
I have a tool to import donations as pairs of invoices&receipts, it can also sets the gift aid & small donation flags. Would this suit you? The file format you would need to make is :-
Code: Select all
BankAccount,CustomerAccoutRef,Date,Ref,Nominal Code,Fund,GiftAid,Department,Details,Net,TaxCode,Tax,SmallDonation
Each line makes 2 transactions in sage an invoice and a receipt.
It would be possible to do a similar thing to post a journal, I am sure.
Re: Uploading from excel to sage 50 jnls
Posted: 27 Aug 2020, 10:16
by Cathy
I am trying to import a perfectly balanced journal into Sage, but am getting 'Error in record x: Contributes to an unbalanced journal for date (credits exceeds debits by x.xx)' when importing into Sage Accounts for every line of my journal. I have tried everything i can think of. Can anyone help?
Re: Uploading from excel to sage 50 jnls
Posted: 27 Aug 2020, 11:30
by brucedenney
Sure, please attach the csv file you are importing to your reply and I will take a look.