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.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Uploading from excel to sage 50 jnls
-
gerryturley
- User
- Posts: 1
- Joined: 02 Jun 2020, 14:25
- Sage Version: v2016 22 UK/Europe/Africa
-
brucedenney
- Site Admin
- Posts: 4665
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Uploading from excel to sage 50 jnls
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 :-
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.
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 It would be possible to do a similar thing to post a journal, I am sure.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Uploading from excel to sage 50 jnls
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?
-
brucedenney
- Site Admin
- Posts: 4665
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Uploading from excel to sage 50 jnls
Sure, please attach the csv file you are importing to your reply and I will take a look.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 25 guests