I am setting up a new business entity. What is the most highly integrated pair of
Does anything like this even exist?
I am setting up a new business entity. What is the most highly integrated pair of
Does anything like this even exist?
Great business idea. Everyone has the need or has created their own version.
Great question. I've always felt that Quicken does this well for consumers, but I haven't found it as easy with accounting/ERP solutions.
NetSuite Cloud ERP has comprehensive bank and credit card processing and reconciliation capabilities. The system has built-in eBanking, so all payment transactions can originate in the ERP system with proper controls. One can import online banking data in QFX, OFX or QIF file format directly. At least one of these file formats is provided by most banks. Upon importing, transactions are automatically matched up for reconciliation allowing for manual matching when necessary.
Depending on the volume of data, one could probably configure a Web Services to automatically grab the banking data and insert it into the ERP system for matching.
It's not perfect, but I use
As a separate sync, QBO downloads bank transactions daily. They are held as "unaccepted" until I confirm or correct the accounting (a debit card transaction at Costco is charged to supplies, a bank fee is charged to bank fees etc.). It "learns" how to handle the downloaded transactions based on prior entries. Bank transactions are "matched" to a prior transaction if the cash outflow is already recorded in QBO (such as payroll and Bill.com entries), or "assigned" and a transaction created if not (Costco debit card purchase). At month-end, the bank recon usually balances without additional work, though not always (and generally my fault).
QBO says it can download from more than 5,000 banks. Bill.com works with a few accounting packages including Quickbooks, Netsuite, Intacct, Peachtree. Per this thread, QBO is generally well-recommended for startups. https://www.proformative.com/questions/user-friendly-accounting-software-for-startups-reviews