Sage 100

Hey Sage gurus! Hoping there is a work-around. Our company has sister companies, and they all have their own Sage company codes with separate books, G/L accounts, etc. However, the three companies all use the same bank account. How can I go about…

Hello, I posted two checks directly to GL using AR Cash Receipts Entry, as I normally would for payments of this type, but they are not showing up in Bank Reconciliation. I've confirmed that they are showing in the GL and that I posted them to the correct…

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…

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.

Does anyone know how to uncheck/unclear/unmark the range of cleared items in Bank Reconciliation without having to do it one by one?

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

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…

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, I have a client who currently generates ACH files from Sage to upload into Bank of America. Bank of America mentioned being able to integrate with Sage, however, after searching online on how this would would or if anyone has done this before…

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…

Able to export and save the positive pay file to the Application Server or the Terminal Server, but unable to save the file to another location on the local network or tsclient. We can export other files and even the ACH file to a local network or tsclient…

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…

What would cause our credit card receipts not to post to our bank reconciliation?

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…

We are on version 5.30.5 and I do not see a Transfer journal as an option when in Transaction journal Entry. We use sweep accounts and I would like one point of entry for these transactions. Do we have to set this transaction type up? If so, does anyone…

I am new to Sage100 and I am working to clean up the company books. We use Sage payroll module and it post to GL but is not in the bank rec. I has been being entered there manually. In order to save time and errors, I would like to show up based on the…

Hello Folks, I'm hoping someone here can help me. I started the Bank Reconciliation for last month, entering the correct ending balance. Out of Balance section was 0 because I just started. The previous months Bank Rec was fine, no issues - I verified…