Browse By Tags

  • AP automatic check is a bank adjustment now

    We have just run into a new issue. 3 automatic ( not manual) checks show up in the bank recap report as "Adjustments" and not check, like everything else. They were printed during a check run with 400 other checks, but they show as 'Adjustment' in the…
  • Make cleaning up your bank reconciliation your New Years Resolution!

    There are several options to void stale, old, prior year checks still showing open in the bank reconciliation in Cash Management (CM). Option 1: Check will not be replaced. Void the check If it's an instant check go to CM, Transactions, Void Checks…
  • Webinar - Bank Reconciliation - Recording available

    Learn how to manually reconcile your bank accounts in Sage 50 Accounts. We'll run through the reconciliation process in simple steps and highlights some of the most common support queries along the way. This session has now taken place, but a recording…
  • Bank Reconciliation add supplier name

    Within the screen BNR0 Bank reconciliation has these reference tables which is OTB GACCENTRY Accounting entries GACCENTRYD Accounting entry lines BANREC Bank Reconciliation Statement BANRECD …
  • Bank feed does not work with Bank Reconciliation

    We have started using Bank Feed to get bank transactions into Bank Rec to clear items. When we download the Bank Feed it imports all transactions not previously downloaded. When we want to do the Bank rec for a month (October) we don't start until the…
  • Masking Bank Account Information

    Hello Does anyone know how to mask the bank account information that is recorded in bank Maintenace? It is required for positive pay; however, I'd prefer if the account info is masked even with admin rights.
  • how to uncheck/unclear the range of cleared items in Bank Reconciliation

    Does anyone know how to uncheck/unclear/unmark the range of cleared items in Bank Reconciliation without having to do it one by one?
  • 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…
  • Duplicated Bank Reconciliation

    A recent File maintenance error check has flagged up that there is an issue with a bank reconciliation from last year. Looking into it there are 2 bank reconciliations for May 2022, both containing the exact same information & both dated & time stamped…
  • How do I void uncleared cheques from prior years

    I have some cheques that were issued in 2020 and 2021 that were never cashed and I want to void them and get them off my bank rec. How would I do this? I will not be re-issuing these cheques.
  • How to record a wire transfer in AR

    How do you record a wire transfer from a customer in AR? In AP there is the selection drop down for Wire Transfer, but not in AR. I read if we use ACH/Credit Card, it doesn't post to BR. So do we use Cash and if so, how/where do we enter the long 15 digits…
  • What's new - October - Easily edit reconciled receipts and payments

    Ever completed a bank reconciiliation and realised that a receipt or payment needs changing? You can now simply edit the reconciled receipts and payments in the usual way. This includes changing the bank account, date or amount. Depending upon what you…
  • Customer account went into liquidation help?

    We have a customer who's company went into liquidation. They then started up a new company under a new company name however a new account has not been set up for them. Just a name change to the old company that went into liquidation. I have only recently…
  • Some bank transactions not appearing

    I'm trying to do my first bank rec for our operating account and am running into an issue. I've linked our bank account, and all applicable transactions show up on the match transactions screen, but when I go to do the bank rec 2 of my May 31st transactions…
  • Positive Pay Export for Union Bank

    Has anyone created a Positive Pay Export for Union Bank or any bank that requires the detail record to be on two separate lines? Here's a sample of the output file Sample data transmission payee positive pay Input format 908123456700002000720312070000029375…
  • Bank reconciliation - Your questions answered

    To help you get it right every time, we've created a guide covering the most common questions around bank reconciliation in Sage 50cloud Accounts. Read more >
  • Sage 200 Professional - How to set up Bank Feeds

    Bank Feeds is a free, secure service that you can use to download your bank transactions into Sage 200 Professional, to help you reconcile your bank account. Read more >
  • Missing a month in bank reconciliation

    Hi, I am having an issue with my bank reconciliations in Sage 2012. It appears I am missing the month of September in my reconciliations, when I go to print a reconciliation report it says no data to show, however all of the other months are available…
  • Make bank reconciliation easier

    When you do a bank reconciliation, to make it easier to find each transaction you can sort the Un-matched transactions window. For example, you may want to sort transactions by date to match the order on your bank statement, or you may prefer to sort…
  • Undo a bank reconciliation

    Sometimes you might reconcile a bank transaction in error, or you may even want to undo a bank reconciliation altogether and start again. Don't worry, there's a few ways you can do this in your software. Find out more >
  • Bank Feed Limits

    Remove the limit on the number of bank feeds available to be set up from 300 to unlimited. Issue 8250. Sage provide the ability to add bank rules for accounts, to remove the inefficiency of manually keying transactions but at the same time put a limit…
  • Reverse Auto Check Reconciliation

    Hello, We began using the Auto Check Reconciliation utility in Sage 100. We imported a list of cleared checks from our bank, with the account number, cleared date, and amount. We proceeded with the auto reconciliation, and now we need to completely…
  • Why can not see bank balance?

    There is only one bank code on my Sage 100. Cash receivables and payables have been recorded on the system and I did bank reconciliation. But I do not see any balance of cash receivables on the GL balance sheet. I would be grateful if someone…
  • Year End Closing and Bank Reconciliations

    I am helping a company that uses Sage 100 and they never closed the year for 2018 or 2019. The cash balance on my bank rec does not tie to the trial balance. I know I can do a hard close to fix that but should I continue doing bank recs in 2020 or wait…
  • Bank Feeds Bank Transfer In / Out

    Would be a useful addition to Bank Feeds to have the ability to "Add Transaction of Type" Bank Transfer In & Bank Transfer Out to reflect what's available on the Bank Reconciliation screen.