Browse By Tags

  • Auto withdraw expense that goes towards a job.

    I'm doing the bank reconciliation. I have a fee that is withdrawn from our account, but it is for a specific job. How do I go about charging that fee to the job plus being able to clear it from my bank reconciliation. I hope someone can help.

  • 1st credit card rec

    I am still waiting for an answer to my question 10 days ago. I started my 1st credit card rec. I entered all transactions from the statement and checked them off. Opening balance and ending balance from the statement. (GOOD) I am good with all postings…

  • Sage X3 - Creating Debit Notes against specific GL accounts

    Hi All! We're using Sage X3 in the US but I think this question would apply across all continents! We have been trying to build out a process for Chargebacks where Debit Notes are created that post against the AR account. Here's the scenario we have…

  • AR Receipt - Special / invalid characters in AR check / receipt field causing Bank Reconciliation issue

    A user entered a '[' within text in the AR Receipt Check/Receipt No. field which then caused an issue in the Bank Reconciliation. We are on version 2014 (300 Premium ERP) (Build 1) (Product Update 1). A posting by Connie H. in Sage Ideas database titled…

  • year end bank reconciliation - bank statement date is Dec 29th not 31st

    My 2023 Dec actual RBC bank statement ends Dec 29th My fiscal year ends Dec 31 2023 there is no banking transactions in my online banking for Dec 30 or 31th. I have not yet received the Jan 2024 statement, obviously bc the month is not complete…

  • How put negative sign in Gst purchases in balance sheet

    Hi there! I have a problem with our sage 50. I am currently a bookkeeper and I having a problem with GSt purchases in balance sheet. It doesnt show the negative sign, and it's adding the gst sale and gst purchase. The previous bookkeper up the books as…

  • upload bank statement

    Hello - Can I convert my bank statement from pdf format to the .ofx for sage upload? I can't seem to find the option when downloading from my bank.

  • Bank Reconciliations

    My bank reconciliation is out, can I go back and re-reconcile an account? Also, we have EFT payments that get removed from the bank at the end of one month, but don't come out of our account until the early days of the next month on Sage. This is due…

  • Bank Reconciliations - How can we find information from previous months reconciliations?

    We are fairly new to Sage 100. We upgraded to Sage 100 in March 2023 due to corrupted data in Sage 50. When we reconciled our bank accounts for March and April, unfortunately we didnt print out the reconciliation and the staff member that completed the…

  • How do I Undo a recent reconciliation so I can rectify something?

    When working with Quickbooks, we have a really easy way to undo a reconciliation to then adjust one transaction and re-save the reconciliation. How do I do that in Sage 100 Contractor?

  • Incoming Bank Transactions : transaction appears twice on VISA statement (2 currencies)

    Hello, In the Incoming Bank Transactions screen for my Credit Card, I see 2 separate entries for the SAME purchase : One entry is in CAD (41.18) and the other is in USD (29.99), as shown in the attached screenshot. Since I work in Canada, I processed…

  • Purchases Clearing Report <> balance with PO clearing GL account

    Specifically asking when you have a PV source journal due to Sage's KB scenario below, what are users best practice recommendations on how they handle the balance sitting in the GL PO clearing account? Do you leave the costs there, reclass somewhere,…

  • Paying invoice that has inventory

    Newbie here. When I go to make an invoice paid that has associated inventory items on the purchase it won't let me change payment to cash so my Bank reconciliation is off by these invoices. So the invoice stays as Pay Later. How do I make these payments…

  • Adjusted book balance not matching statement

    I have reconciled my bank accounts and the correct totals are showing with a zero adjustment required in the reconciliation window. Since this is back work (2022) I am working forward and the balance sheet at Jan 1 2022 is not showing the correct statement…

  • CM Old Uncleared Transactions cannot be reconciled or changed

    We are trying to clear up some accounts that were never properly reconciled. There are several transactions from past years that we need to mark as reconciled. When we attempt to change them in the Edit Register, we get an error that says: Could not…

  • Accounts Rec - Balance Sheet and AR Report Don't Balance

    What reports can we used to drill down and identify why there is a difference between our general ledger AR account and the balance shown in the AR Aging report? We have several months that are balanced - and then we will see a difference... than…

  • Intercompany Transaction - Check Deposited to wrong entity, need help with AR Offset

    Hello all. Not sure why this issue is giving me fits, but I desperately need transaction advice. Background: We have 2 businesses: MYC & SHO. SHO is a non-operating entity, MYC has all operations. Problem: My CEO deposited an MYC customer…

*Community Hub is the new name for Sage City