Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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…
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…
Just upgraded to Sage 2017 version and BR is slooowww. Several checks can't be cleared while others can. When I click "Accept" after choosing the checks again in question, BR will not close or update data. Checks continue to be uncleared. Anyone have…
Good morning! I work at an equipment rental company with seven locations (two more being added within the next few months). The company uses Point of Rental software for the daily business, and each day I download the previous day's journal entries into…
Hello,
I am a new user of SAGE and have just started working as a Controller for a small company. The current practice in our business is to reconcile the bank everyday. In that we download all of our bank transactions and then one by one go through…
I entered a Bank Rec adjustment for Merchant Fees relating to our credit card processing. The fees were deducted on the first for a particular amount. I entered the accrual as a reversing entry to accrue since they relate to the previous month. Then in…
Good morning! I am currently trying to get caught up on some bank recs and have run into an out of balance that I'm not sure how to fix. I have gone through the bank rec module and clicked all of the checks that cleared, all of the deposits, and all of…
We have a client with approximately 14 companies that are all similar. After a recent upgrade to 2016, Manual Checks from about half those companies no longer post to the Bank Rec transactions although they appear to adjust the Bank balance in Bank Code…
I have been using Sage 100 for about a year... it's been a steep learning curve but I'm getting there. I am an office manager who make lots of entries in the GL but I also oversee the entries of two other bookkeepers who do the RA and AP. (Which is to…
Sage 100 ERP
Having trouble getting my Bank Rec balance to match up with the GL balance. As far as my eye can see everything seems to match. But obviously there is something off on one of the sides that I cannot locate. I am starting to think that perhaps…
Bank hasn't been reconciled in 10 (ten) years. There's a $30 million difference. How do I get it to zero and start fresh? KB Archive advice is outdated for today's version of Mas90.