Matching invoices with unallocated payments

I've inherited a set of books that are rather messy. Summary shows thousands of dollars in very old unpaid bills. When I check through I can see the payments were made separately as 'other payment' and not allocated to any invoice and they show up on the unallocated payments report. The invoices were entered but the payment doesn't show as being made. How do I connect those payments with the bills? I'm hesitant to reverse payment and re-enter as they are from previous years where tax reporting has already been done and accounts reconciled. Is there a way to simply connect a payment to a bill?

Parents
  • 0

    Hi ,

    Thanks for reaching out, was this for Sage 50 CA? If so, then please post your question in this forum for Sage 50 CA General Discussion so that other users of this software will see it and can offer you their thoughts and insight.

    If you are using Sage Accounting Canada then to:

    Unallocate from an invoice

    1. Open the invoice from the Purchase invoice list or from your Contacts List:
      1. From Purchases, select Purchase invoices, and open the relevant invoice.
      2. From Contacts, select Suppliers, open the relevant supplier, then the relevant invoice.
    1. From the Payments section, choose the Payment link under the Amount Paid.
      This will open the Payments and Allocations screen. You will see any allocated payments, Refund options or credit notes displayed here.

    2. select    in the Refund column, where you'll have an "Unallocate - Detach the payment from this invoice, and record as a payment on account" option.
    3. (optional to adjust amount allocated) Select the link in the Amount column.
      If your invoice was paid via allocation this opens the Account Allocation section.
      1. Clear the tick box next to any credit notes or payments you want to unallocate, or if you just want to adjust the amount paid, select   and adjust the Amount to Pay.
      2. Adjust the amount paid on the invoice to match the amount unallocated. Select   next to the invoice, and reduce the Amount to Pay by the total of the unallocated payments or credit notes.
      3. Select Apply.
      4. Make sure the Left to Allocate amount is zero and Save.

        If your invoice was paid via Supplier Payment clear the tick box from the invoice you want to unallocate and Save.

    Thanks,

    Erzsi

Reply
  • 0

    Hi ,

    Thanks for reaching out, was this for Sage 50 CA? If so, then please post your question in this forum for Sage 50 CA General Discussion so that other users of this software will see it and can offer you their thoughts and insight.

    If you are using Sage Accounting Canada then to:

    Unallocate from an invoice

    1. Open the invoice from the Purchase invoice list or from your Contacts List:
      1. From Purchases, select Purchase invoices, and open the relevant invoice.
      2. From Contacts, select Suppliers, open the relevant supplier, then the relevant invoice.
    1. From the Payments section, choose the Payment link under the Amount Paid.
      This will open the Payments and Allocations screen. You will see any allocated payments, Refund options or credit notes displayed here.

    2. select    in the Refund column, where you'll have an "Unallocate - Detach the payment from this invoice, and record as a payment on account" option.
    3. (optional to adjust amount allocated) Select the link in the Amount column.
      If your invoice was paid via allocation this opens the Account Allocation section.
      1. Clear the tick box next to any credit notes or payments you want to unallocate, or if you just want to adjust the amount paid, select   and adjust the Amount to Pay.
      2. Adjust the amount paid on the invoice to match the amount unallocated. Select   next to the invoice, and reduce the Amount to Pay by the total of the unallocated payments or credit notes.
      3. Select Apply.
      4. Make sure the Left to Allocate amount is zero and Save.

        If your invoice was paid via Supplier Payment clear the tick box from the invoice you want to unallocate and Save.

    Thanks,

    Erzsi

Children
No Data