Any non-Tax accounting topics go here.
QBO Bank Feed
OK so after many years of keeping this largely to myself, I have to ask - what is the point of a bank feed? We have numerous clients where the accounting records consist of nothing more than what ends up on the bank statement. The bank balance is miraculously reconciled to the statement each month. Some clients enter some, but not all transactions, so that leads to transactions being matched. Other clients do a pretty good job of using the memo line to describe a transaction. What if we end up accepting the bank feed entry? Does the thoughtfully-written memo disappear into the ether?
My employer thinks I have a closed mind over this (and other) topic. He wishes to be more than a tax shop and to sell added value services to clients. I have tried to explain to him that I do not understand why relying on the bank feed facilitates that (which is what provoked the closed mind comment, I think). It seems to me that if a client desires quality information, it is just as easy to get into a regular pattern of posting to the accounting records and doing a proper reconciliation.
I am working through the QBO certification, in the hope it will give me a better understanding of the software. So maybe I just haven't learnt why bank feeds are important. Can anyone enlighten me, please? I should mention that I learned accounting at high school in Scotland using pen and paper and the first few years of my working life were with manual systems.
I haven't worked with QBO bank feeds, but I imagine they work the same as desktop.
The point of them is to eliminate manual keypunching, pure and simple. If someone enters all their transactions manually, great, but look at all the time spent, and the possibility of typos and other errors, which hopefully will be caught in the reconciliation process.
The "rules" that you can teach to Quickbooks for processing bank feeds can make data entry very easy. Based on the info downloaded, the transaction can be assigned a payee and account automatically, and of course the date and amount are also captured.
re: matching. If the transaction has already been entered, usually QB can match the import data to the existing transaction and then it will skip the import for that transaction (so no, it won't overwrite the memo field). So, you can effectively use bank feeds in a hybrid fashion (part manual entry, part auto download).
For example, I use QB for my own personal financials. I manually enter the "big" transacts as I make them, but I would be bored mindless if I had to manually enter every grocery store and gas station transaction by hand, and I probably wouldn't do it in detail. Downloads makes very quick work of that.
For several decades last century, I had my own double entry bookkeeping system (written in the venerable R:base system, a competitor of dBase back in the day). I collected all my receipts and then once a week or so had to keypunch them in. I'd never want to go back to doing that again, I regret the hours of my life I wasted doing it.
The thing about bank feeds is they are excellent when they work properly AND they are being managed by someone that knows what the heck they are doing. They become an absolute nightmare when the opposite is true. I use bank feeds for my personal and business accounting, but really dislike seeing clients use them in almost every case. Why? They create problems by not paying sufficient attention to the account activity. Worse, unlike QBD, QBO will automatically create adjusting entries to force a reconciliation and those entries get posted to an income statement expense account called "Reconciliation Discrepancies." Sure, they should be cleared out, but no one ever does. Intuit does an excellent job of promoting terrible bookkeeping by allowing everyone with an ability to buy software to think "I got this."
Back to a scenario where the feeds work properly and there is a brain attached to the arm moving the mouse. If a transaction is already entered, it will typically automatically match up and the bank feed transaction is disregarded. Sometimes, you need to look for an existing transaction to match up, such as if it was posted to wrong account or dollar amount is off. Also, if it is a recurring transaction and a rule has been created, you will be able to tell when that rule has been applied, but it takes a look of the eye to pay attention and notice, because sometimes the rules end up being overridden by a click-happy user, or no longer applicable.
Now let me give you an example of when I HATE bank feeds, or any automatic feeds into an accounting system, when not done routinely by someone that understands what to look for and why. I have a client who relies on their POS and merchant processor feeds to automatically post sales transactions to QBO, and bank feeds for three bank accounts and two credit cards. During 2018 (and likely 2017, but that is not my concern at the moment), easily over half of the transactions that are on the bank statements are completely missing from QBO. They either never made it into QBO through the feeds, or were deleted (former is likely culprit, which I have seen happen many times). Deposits are not matching up, and instead just end up sitting in undeposited funds for perpetuity.
Another issue is the banks themselves. Some support QBO, but not QBD. Some charge for a QBD feed but not for a QBO feed. There is no consistency, and banks also update their systems with no regard for what customers will face when their feeds are broken. What happens more often than not, in my experience, is the customer(s) create a mess trying to resolve a broken feed rather than getting their accountant involved where it can be kept as clean as possible.
When done correctly and routinely used, they are an absolute life saver in terms of efficiency. When done in the hands of someone that does not understand how and why they can create issues, they can be a nightmare. I encourage bank feeds when used by competent bookkeepers and accountants, yet highly discourage them being used by clients unless they have a solid grasp of bookkeeping, at minimum. Bank feeds make bookkeeping/accounting appear too simple, and people tend to then treat it as such and miss critical steps, INCLUDING actually reconciling the accounts.
Intuit does an excellent job of promoting terrible bookkeeping by allowing everyone with an ability to buy software to think "I got this."
About the only good thing is the account called "Ask My Accountant". At least I can find all those entries, rather than posting/hiding them somewhere in the GL.
I agree 100% with the entire previous post! Reconciliation discrepancies with more than $15,000 per month (really?? cash is off by $15,000 and you don't know why???). A gazillion vendor names such as "transfer to XXX 112018", "transfer to XXX 113018", etc. Ridiculous! Makes 1099 reporting a nightmare. And again, the undeposited funds account. Nightmare!
Thanks for the comments. My employer outsources bookkeeping to India and, today, we have told them not to do bank feeds for our largest client. We had duplicate entries for a very large credit card bill for almost all of 2018 which buggered up the numbers for state extensions due today. They also dumped about $300,000 in expenses straight into Ask My Accountant, which they were specifically told not to do.
Cornerstone, you articulated many of my concerns. Your last paragraph, in particular, resonates with me.
I just read through this thread. I have a client using an industry specific software. Earlier this year the software company started offering bank download capability, but at least the client has to sign up for it, it's not automatic. They use PO's and proposals extensively and all of their transactions relate back to those two processes. Entering data in the program is not simply a matter of debit or credit something, almost without exception all transactions are tied to either a PO or a proposal. The bank just can't do that and I discouraged them from allowing the automatic bank feed for that reason. I can't imagine how much time would be wasted trying to correct all of that work every month. Sometimes when there is an error it's so difficult to get it fixed, trying to do that with a high percentage of the transactions would be a horrible nightmare. Usually once a new process like a bank download has been implemented, there is no going back, you can't change your mind.
I worked with a large consumer goods company that, like your client, almost everything tied back to sales orders and purchase orders. Anything concerning bank accounts was manually entered and reconciled on a daily basis, too much volume to deal with otherwise. Bank feeds would have been an absolute nightmare, though they have gotten better in terms of what you can do with them.
I 100% discourage use of bank feeds by anyone except those that truly understand accounting and how to correct issues that those feeds may create.
"When done correctly and routinely used, they are an absolute life saver in terms of efficiency. When done in the hands of someone that does not understand how and why they can create issues, they can be a nightmare."
Completely agree. But unfortunately, it's like driving an automobile -- probably a third or more of the car-driving population has no business being behind a steering wheel, yet they think they know what they are doing, and in order to provide them with the illusion of increased efficiency, the rest of us must suffer the consequences.
This topic strikes a nerve with me. I have always maintained the crux of the problem for most clients is not the mechanics of the program (i.e., entering invoices, etc.) but lack of accounting knowledge. Some clients seem to think any idiot should be able to buy the program and be up and running - like the old Quickbooks commercial "I have QuickBooks now I can fire my accountant". And that is exactly the issue; just because you can generate invoices and pay bills doesn't mean you know accounting. If the set-up is wrong, transactions are categorized incorrectly then guess what your taxes will be wrong, any financials provided to internal and external parties will be wrong, your cash flow won't be accurate and so on. S
Most of my clients under 40 don't know what a bank reconciliation is and of course they simply accept the bank feeds transactions.
The other issue with the bank feeds arises when the program is used for job costing. Transactions coded with items can't be matched with the downloaded transactions from the bank. So yes that means entering the transactions by hand.
Know what you don't know and find someone who does and get on with the business of running your business...
Know what you don't know and find someone who does and get on with the business of running your business...
DING DING! That is the fundamental issue. Overall, people do not want to admit what they do not know. They do not want to focus on their core competencies, even if it means they can succeed at a far higher rate by doing so and leveraging the core competencies of others.
In some ways, I have found it lucrative to just educate my clients about what they do not know. They appreciate that I am not trying to take over the work, and I earn money in the process. Eventually we reach an equilibrium where they are doing what I need them to do (and properly), I do what they need me to do, and it just "works."
dsocpa wrote:This topic strikes a nerve with me. I have always maintained the crux of the problem for most clients is not the mechanics of the program (i.e., entering invoices, etc.) but lack of accounting knowledge. Some clients seem to think any idiot should be able to buy the program and be up and running...
Yes, that is Intuit's sales pitch: "Accounting is simple. The less you know the easier it is." Most clients seem to be pretty receptive when I tell them that buying the program does not give them accounting knowledge. I also had problems with especially credit card feeds. About a third of the transactions was missing. Bank feeds can create time consuming problems. One client paid invoices but slightly different amounts. Now we have to adjust all the invoices to match them to the payments. QBO is quite inflexible. Accounting problems we can solve have been replaced by software problems we can't always solve. QBO and bank feeds works best for a small business, cash basis, who doesn't use it for invoicing and vendor bills.
Now add merchant accounts into the mix, with an inexperienced user. What a damn mess when bank feeds are used. I have a client that uses Intuit Merchant Services, Square, Stripe, and Poynt. Intuit is used for wholesale, Poynt for POS, and Square/Stripe for events. All feed into QBO in one way or another, but then the friggin' bank feeds import the settlements, too. It is impossible to determine which transactions make up settlements from any merchant account but Intuit Merchant Services. I am in process of cleaning up this client's accounting, so if it is Square, Stripe, or Poynt, I am doing my own entries and will wipe out everything that was fed in from bank feeds and the QBO integrations.
Powered by phpBB © phpBB Group.
phpBB Mobile / SEO by Artodia.