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…
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…
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…
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…
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…
Hello,
I am working on a file and I am just starting the bank reconciliation. Year one was done by someone else and I can't get the sage file for it so I have a carry forward bank balance of 1303.02. How would I go about setting this up as a first…