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

Uploading from excel to sage 50 jnls

Sage 50 general help forum - Free help and support for all general issues
Post Reply
gerryturley
User
User
Posts: 1
Joined: 02 Jun 2020, 14:25
Sage Version: v2016 22 UK/Europe/Africa

Uploading from excel to sage 50 jnls

Post by gerryturley » 02 Jun 2020, 14:56

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.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Uploading from excel to sage 50 jnls

Post by brucedenney » 03 Jun 2020, 10:55

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.
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.

Cathy
User
User
Posts: 1
Joined: 27 Aug 2020, 10:05
Sage Version: US Sage 50 Version (Peachtree)

Re: Uploading from excel to sage 50 jnls

Post by Cathy » 27 Aug 2020, 10:16

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?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Uploading from excel to sage 50 jnls

Post by brucedenney » 27 Aug 2020, 11:30

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 25 guests