• AR Specialist Job Opening

    AR Specialist needed. Experience with Sage 100 Contractor Area: Santa Fe Springs, CA 90670 Company: Quality Environmental Inc. Contact: Erika Meza de Borjas (562) 941-1434 - [email protected]
  • I entered a check deposit under Deposits/Interest. However, when I go to Bank Reconciliation the check deposits comes out to zero. When I go the GL the deposit appears twice and cancels the amount out to zero.

    We recieved a refund check from the state in the amount of 1,977.25 and I need to record the check that has already been deposited into our cash account for bank reconciliation. I entered the deposit under Deposits/Interest and only entered the amount…
  • Voiding a credit to an invoice.

    How do we void or edit a credit to an invoice? The wrong account was used when the credit was input and when we go to void the credit Sage says "unable to locate ledger transaction for this record". Thank you for your help
  • Applying payments for AR Invoices that were applied in the wrong order

    Firstly, We have 3 invoices 11113355, 11113356, 11113357. Invoice 11113357 was created to hold retainage for the previous two invoices after we received payment and realized retainage should have been held but was not originally. Therefore when…
  • Can I unapply an AR cash receipt that was applied to an invoice in a previous year?

    I have a cash receipt that was applied to an invoice last year that I would like to unapply from teh invoice and void the invoice. Is this possible to perform once I close out the year (i.e. perform the task in the current year) or do I need to unapply…
  • AR

    Wondering if anyone can tell me how to change a date to a reconciled AR item. I was able to change the item in CM to be O(open) from (R)reconciled. I now need to change a date from 2021 to 2022. The bank reconciliation is now out of balance because of…
  • A/P-A/R DPO - Owner Direct Purchase

    We are using Sage 100con. We purchase items from a vendor and receive an invoice that is then paid for by the GC and we are given a deductive change order on the progress billing. How do we show the open invoice in AP paid for against the progress billing…
  • Accounts Receivable showing "Not Used" on Aging Report

    My Accounts Receivable person did some adjustments to clean up our aging report. Not exactly sure what was done, or how done, whether it was by AR Credit/Debit, Billing Credit/Debit, etc.but now I have "Not Used" on the aging report listed under the clients…
  • AR Adjust Receivables Summary entries in Revenue accounts

    My company has many entries hitting our Revenue accounts with the description "AR Adjust Receivables Summary". These entries are reducing our Revenue account balances. I do not see any offsetting entries in AR. Any ideas on what these entries are?
  • Entering a job deposit/retainer

    I'd love to hear how others enter job deposits? We use Progress billing as well as Time & Material billing as the Invoice Detail for each Progress Invoice. Thanks!
  • Billed Retention Entry

    When retention is billed at the end of a project, our AR module makes an entry to move the rentention out of "retention receivable" and into "current contracts receivable" and moves the amount to our "current" column on our AR Aging Report. Our auditor…
  • Accounts Receivable

    My A/R person did something with voiding or adjusting payments to an open invoice. Somehow there are now postings to the A/R (reflected in the aging report) that state "Not Used" under the Tran Type, and gives a Non-Job negative amount. Since I cannot…
  • AR Billing - Job # change

    Can a Job # be changed for an invoice in A/R, Billing or Job cost once an invoice has been created and paid?
  • One of our customers owes us 10 cents. How do I get it off of our books?

    We sent a billing out for 1,290.10 well they only paid $1,290.00. Their system rounds as to mine does not.... How can i get that $0.10 off my books???
  • Job Income

    We wrote a check to our client to return their share of cost savings on the completed project. How do we decrease the income on the job to reflect this? I charged the check to a misc GL account until I could figure how to this this correctly.
  • credit card details load into the GL

    new to Sage 100 C. What is the best way to enter CC transaction details into AP? Create CC setup (for each user) and then enter a payable for each transaction with a payment method of CC? You then reconcile the CC statement and select to pay the CC? Or…
  • Billings AIA overbilled line item so now my line item "balance to finish" is a negative amount

    My line item the scheduled of value is $14,500.00. Well i billed $15,840.00 so now there is a negative about on balance to finish. Anyway i can correct it? The billing happen in 2018 it is on on going job. Im ready to bill again....
  • Adding AR Retainage to an Inquiry

    I am trying to add detail retainage by invoice to an AR inquiry. The inquiry is based on the AR - Status table. I selected this table because it allowed me to see the AR information by customer by invoice and includes cash receipts that were posted to…
  • How to correct duplicate Misc. Cash Receipt entry

    The same Misc. Cash Receipt was entered twice, on different dates. Since it was not payment towards an AR customer account, how do you correct the duplicate entry?
  • State Sales Tax and the GL Account

    Our General Ledger only has one account 22000 called Sales Tax Payable. We have 3 States all going into this one Liab. I created 3 subaccounts, CT 22001, NY 22002, MA 22003 and made 22000 the Summary Account. How do I assign a GL account to each…
  • Customer Deposits to Liability Account

    How do I enter customer deposits to the liability account, then deduct it from their final bill to debit the liability? There dosen't seem to be an easy way to enter, apply, and deduct in billing or accounts receivable. I figured out how to enter a…
  • Cash Receipts

    I entered at cash receipts in AR - i thought i had post to GL and CM turned off - it is not hitting the GL, but it is posted in the CM Reg, I deleted it thru AR Adjust Receivables - but it is still showing up in the CM reg??
  • T&M with GMP

    FormerMember
    FormerMember
    I am fairly new to Sage. I have been working with it for the last 4 years in a small capacity. I recently have began using the software in its full capacity and have questions on Billing and the best suggested ways to bill a client that is a Guaranteed…
  • Removing or Decreasing A/R Invoice

    Hello, I am new to Sage and have found that you can not do a JE to reduce an A/R invoice attached to a job. My client received payment for a particular invoice long ago yet it still shows in A/R so how would I remove that invoice without voiding it…
  • AR: Small open balance on client invoice. Best accounting practice to resolve?

    FormerMember
    FormerMember
    If you have a client that isn’t going to pay a small amount of an open invoice, how would you handle that? There seems to be a couple of options. Wondering what your opinions are.