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…
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…
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…
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
…
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…
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.
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…
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…
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 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…
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…
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…
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…
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…
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 >
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 >
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…
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…
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 >
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…
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…
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…
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…
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.