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…
Just released: Sage X3 v12.0 1099 2022.
We're thrilled to let you know that the Sage X3 v12.0 1099 for 2022 is now available to download from the Sage Knowledgebase.
Head to Knowledgebase article Download Sage X3 Version 12.0 1099 2022 to download…
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…
For our Sage Fixed Assets—Tracking customers, version 2.1 of the Sage Fixed Assets Scanner app is available in the Google Play Store .
This release includes maintenance updates and a customer-requested enhancement to filter the Asset List by New, Found…
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…
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…
We are network cabling contractors using Sage 100 with Job Cost and lost our Sage 100 support person. We have a CPA, but need someone for quarterly/year end closings.
Located in Orange County, CA near John Wayne Airport. Any referrals would be appreciated…
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…
Hello,
Has anyone used the "Bank Statement Entry" function? I would like to enter some payroll checks into the bank reconciliation without touching the general ledger as there is a separate g/l batch brought in for this purpose. I noticed that if…
Attempting to enter a check during Bank Rec. I want post to the GL. I enter a distribution account number but get the error "distribution accound number required" I have tried to copy it from the lookup and type it in.. can't get past the error.
Hi
We are looking into switching banks from Wells Fargo to a smaller institution that is aligned with our values.
The bank we are looking at does not provide custom designed files for use with Sage 100's Auto Check Reconciliation. Can someone tell…
I am trying to check the box under GL Options for Integrate with Bank Reconciliation and I get this message: You cannot enable or disable integration to Bank Reconciliation while Transaction Journal Entry is in progress. I do not have any TJE in progress…
Hi all,
Do you know if items that are outstanding on the Ledger and Statement still show as outstanding after an acounting period is closed?
Also, there is any report that can support this?
It seems that X3 is still vague in this kind of issues…
Help please,
I am almost positive my Sage50 bank reconciliation has glitched in some way. I attempted to reconcile the account with my bank statement - everything matches up.
I have the correct: statement start date; statement end date; statement…
I am fairly new to using Sage (though our accounting team is not). We recently activated our bank reconciliation module and were supposed to have training from a Sage expert, but they retired before we could learn how to set it up and get started for…
bank rec becomes out of balance by the first entry in dep/adj window even if no other transactions have occurred and it had previously been in balance. this happens over and over and in multiple companies and multiple users. this is in version 2015. i…
Is there any way we can get it to put the amount that was debited or credited for each item on the Transaction Journal, using a specific account, for example, 1030-001, instead of what was posted to the various General Ledger accounts.
I noticed that…
We have several loan pmts that are auto drafted on our bank account. I would like to set them up in recurring journal entries as cash disbursements, but it looks like if I do them that way, they do not show up in bank rec. How do others do this?
I have a small company that only writes a couple of checks a month. I have entered the checks in the Bank Reconciliation-Check, Deposit & Adjustment screen and marked them to post to the ledger. I can not seem to run any type of transaction journal that…
