How do I direct payment from our chequing account to a sales revenue account?

I just started in this business a month ago, and the last girl that I replaced was let go, so I have no one to train.  This support group is the best I have at this point since we have the 2014 version of Sage 50 and my boss doesn't know how the last girl did anything.

We have Sales Revenue accounts for Red Cross Programs.  We put our invoice to go to the Red Cross Program account, and when someone comes in and pays for their Red Cross CPR First Aid training, it adds the money to our Chequing Account, but it also raises the amount in Sales Revenue Red Cross Programs.  It also does this for a few other accounts.

The problem we're having that I can't figure out, is this: 

We have a Sales Revenue account for Personal Support Worker Level 1 (which is where students pay so much a month for their training to be a Personal Support Worker).  When the invoices were created last year, the invoice is set up for the Personal Support Worker Level 1. When someone comes in to pay, let's say Sally pays $500 out of the $1,500 that is owing, it adds the money to our Chequing Account, but it does NOT raise the amount in the Sales Revenue Personal Support Worker Level 1.  I've tried everything, but I cannot figure out how to add that revenue account.  We don't have to do anything special for the Red Cross Program Sales Revenue account to work, so I don't know what could be wrong. 

  • 0
    First, in your mind, you have to separate the concepts of invoicing from cash flow. Invoicing increasing the revenue of the company and usually what your customers owe assuming the invoices are set to Pay Later.

    When payments are made, the amount the customer owes goes down, and the amount of money in the bank goes up.

    That's the English.

    The Bookkeeping:
    Invoice a student and the balance of the revenue account goes up and the amount of money the student owes you goes up (balance of the Accounts Receivable account - you will see this on the Customer Aged report on the Reports, Receivables, Customer Aged menu).

    When you receive a payment, you go to Receipts, enter the payment against the customer/student and invoice(s) paid. This increases the balance of the bank and decreases the balance they owe.

    At each stage, you can review the journal entry report from the Report menu to make sure of what is actually happening.

    I've never seen the receipt of money increase the bank balance and revenue accounts at the same time unless you are posting a sales invoices that is other than Pay Later.

    So go back to the entries using the lookup feature on the Sales or Receipt menu, figure out which module they are posted in (Sales invoices vs. Receipts, etc.) and whether you are posting the sale at the same time as the payment (eg. in Sales Invoices, Pay Later is changed to Paid by Cheque or Cash or credit card, etc. - a dropdown below the menu and toolbar on screen). It allows you to do both invoicing and receive money at the same time, but you have probably said that you changed this option when you described it. However, you have led me to believe that they are two individual entries.

    Once you do that, then come back and let us know what has happened and what you don't understand. Then we can help better.

    One other thing. If you already posted an invoice to increase revenue, payment should not increase revenue again. It sounds like you want it to but it shouldn't.