• Importing invoices data from Chargebee in Sage 50 CA

    We are using Chargebee to generate our invoices for all recurring customers and we want to import the invoices’ data from Chargebee into Sage 50CA.

    Any suggestion on how to execute this basic accounting process?

    Thanks in advance

  • Year End carry over

    Client was invoiced May 16, 2019 and paid invoice in full via Interact May 31, 2019 (Year End) . It was not posted by bank until June 4, 2019 (New fiscal year). What do i do for an entry so i can reconcile May and June properly? 

    Thank you 

  • Data Integrity Check - difference between A/R balance and Unpaid Invoices

    I have just noted a difference of 0.01 between my A/R balance and Unpaid invoices when I ran a Data Integrity Check.  When I investigated, I found that the difference arose on the translation of a foreign currency receipt to the home currency.  The translation…

  • Journal entry flow when invoicing, and receiving funds through our stripe account.

    Hi,

    I have just linked our Stripe account with our Sage software.  Before I begin using this feature I would like to make sure I have it set up correctly and that I know what the flow of Journal entries will be.  

    When I create an invoice through the receivables…

  • Receiving online payment with fees - pros & cons

    I'm new to the online payment receipt in the AR, i'm looking for the pros and cons to using this in the receivable module.

  • A/R 1200 Control Account

    Hello I have a novice question.... but it is really holding up my production. When I issue an invoice in "Revenues" and then a "Receipt" when payment is made, is that payment automatically linked to the1200 A/R Control Account in the COA? I am carrying…

  • INVOICING PROGRESSIVE BILLING

    Is there a way to keep track of materials used and labour for a project on excel and export it into sage as a sales invoice? I have been weeks trying to figure out the easiest way to keep track. I could use time slips to keep track of labour but it doesn…

  • combine two Accounts Receivables

    I am trying to combine tow A/R into one.

    here is the scenario: A/R account has an account left over from last year. So when I tried to add to it it didn't allow me, the account didn't show up as it is a control account. Than I changed it to A/R general…

  • linking two accounts Receivable to balance data integrity checks

    Hey there,

    When setting up from our last accounting software we had two accounts receivable, one in cad $ and one in us $, as well as three accounts payable, the extra being for GBP. When linking my accounts receivable to my customers for the linked account…

  • Transfer A/P amount to A/C to clear?

    Hello,

    Instead of making a purchase voucher, I made a general journal entry and cleared the accounts payable account via cash. However, instead of this amount linking to the accounts receivable, I know have amounts in both A/P and A/R. How can I transfer…

  • Data inconsistency in A/R Listing

    I have 3 issues; not sure if they're related. It is a foreign currency set-up, and I'm aware of the Knowledgebase article saying that one should call Sage support for database repair -- but I'm not sure I'm at that point -- would prefer to explore ideas…

  • Foreign Currency Transactions

    Our company is CDN but also does business in the US. So, we have set up a US bank account. We invoice our US customers in US funds and they pay accordingly. We also purchase US products (COGS, etc.) and pay for these using our US account.

    My problem is…

  • Exporting Monthly Statements

    Hello Sage 50:


    Is there a way to export (or print to a csv file) monthly statements that can be opened in Excel?
    I have looked around the program but to no avail. Any suggestions on how to achieve this.

    Thanks,

    Dave

  • Sage will not email out sales invoices

    Sage will not email out sales invoices, it looks like it does, but no copy in my outlook send folder.  It was working last week.

  • Aged Receivables report settings

    My aged receivables report shows the invoice date and due date as being the same such that the "Current" column is empty and everything is overdue. How do I adjust my settings so that only invoices unpaid after 30 days show up as overdue?

  • Year End ADJ Entries to Accounts Receivable / Meals ???

    Hi, 

    I am entering the Year End Adjusting Entries from the Accountant.  I am almost done.  

    I have one problem left though.  My A/R is out by $0.09  interestingly, so is my Meals Expense account.

    If I could Dr. the A/R and Cr. the Meals everything should be…

  • Accidentally reversed receipt for NSF cheque

    Hi There,

    A customer had some bank issues which caused many of his payments to be returned.  He advised me of this in advance, but I had already processed and deposited his payment, which covered several invoices.  He came in to rectify the situation once…

  • Posting to A/R in a foreign Currency as an adjusting Y/E Entry

    Hi I need assistance please:

    In the previous fiscal year we generated an invoice for USD (in a foreign currency) $1080.04.  The client paid the amount via a wire transfer and the invoice in Accounts Receivable has the PAID on it.  However, the Accountant…

  • Paid sales invoices reversed just in GL

    Hi,

    I cannot figure out how 2 receivable JEs got reversed only in GL. The invoices are still there in the Sales Journal and have a payment recorded again them. In fact the payment was applied to 6 invoices and none of the invoices were reversed. There is…

  • Reversing Old Invoices

    I am currently trying to reverse older invoices as opposed to writing them off to bad debt.

    I am able to pull up the old invoices, but upon clicking the "Reverse Invoice" button I receive a message that says "The transaction cannot be adjusted because…

  • Deferred/Unearned Revenue

    I need some help with recording deferred/unearned revenue in Sage.  Does anyone have experience with this function in Sage?  The customary way does not seem to work in Sage, so I need to know how others have recorded it.

    Please help!

    Thank you.

  • Overpayment

    Hello,

    I am currently dealing with an overpayment which is by sense a duplicate payment where the first payment was short.


    We got an EFT notification (confirmed deposited in out account) for 6,586.00 for an invoice worth 7,442.18. It is company policy…

  • Wrong Interest Rates on Accounts Receivable

    Since upgrading to Sage 50 Quantam 2015, Sage has stopped accurately calculating interest rates on A/R balances. Previously, any outstanding balance was charged interest at 12% per year... this works out to a daily compounding rate of 0.0328%. The customer…

  • How to balance prepayments in history??


     

    Background: This is the first year of business. The books are being transferred to Simply.

    I'm unable to proceed from history mode until I've balance the Prepayment account balance to the Pre-order/ Prepayment along with the Deposit account balance…

  • multiple clients on one payment

    Hi, our company has multiple clients for the same product (service) with 3 managers, each over a portion of these clients.  These managers collect payment from some of the clients, other clients mail a chq to our office.  These managers will then make a…