SimpleQB also lets you automatically link scanned documents or network files to QuickBooks transactions.
SimpleQB lets you import QuickBooks transactions in batches from a database. When combined with SimpleIndex OCR and barcode recognition this creates a fully automated solution for tasks like receiving bills from invoices. Watch the demo video to see SimpleQB in action.
SimpleQB is a powerful tool for exchanging data between any database and any QuickBooks transaction. It works with SimpleIndex by sharing a common database where document data is stored. SimpleIndex exports document indexes to the database, then SimpleQB imports that data into QuickBooks.
The database can also be used to find and view documents linked to transactions in QuickBooks
Because of this open design, SimpleQB can be used with any scanning application or database, including more advanced software that can recognize line items and other repeating elements on invoices.
SimpleQB demos are available by request only. Please Contact us to request a demo.
What is Document Imaging?
Document Imaging was the more commonly used term in the early days of document scanning and OCR and refers to any system used to replicate documents used in business. It evolved from the microfilm days where it was referred to as Document Image Management.
Document Imaging allows for the scanning of paper documents, as well as the processing of files saved electronically. These files are then named and saved for later searching.
Other document imaging terms include automatic imaging software, best digital imaging software, best imaging software, desktop imaging software, digital document imaging, digital imaging software, document imaging download, document imaging PDF, document imaging processing, document imaging products, document imaging software, document imaging solution, document imaging solutions, document imaging systems, document imaging technologies, document imaging technology, document imaging tools, image to database, imaging resource, imaging scanning software, imaging software companies, imaging software download, imaging software for windows, imaging solution, scanner imaging software, scanning and imaging, scanning imaging, and software for imaging.
SimpleQB – QuickBooks Company File Warning
If a message that indicates what QuickBooks file that SimpleQB will be uploading with and OK or Cancel option is required to avoid accidentally uploading into the wrong QuickBooks company file when multiples are used. “Be advised: selected procedure “SimpleQB Config Path” will be run in the currently open company file “QuickBooks Company Filename”. Click OK to Continue procedure or Cancel to abort”
Navigate in the Windows Registry to this location:
HKLM\Software\SimpleIndex\Misc
Then open this file:
QBFileWarning
Then change the value from 0 to 1
QuickBooks must be restarted before the change takes affect.
Is it possible to search for and retrieve documents with Windows desktop search?
Windows Search works great with SimpleIndex because all index data can be saved to the folder and file names as well as the file properties, and OCR text can be saved to hidden layers in PDF files. Windows Search will read all of these elements when building its index and will return any matching files when you search.
Using Windows Search on a file server allows for instantaneous searching across terabytes of documents and text for all of the users on your network.
IFilters allow Windows Search to search within file contents.
Here are three popular PDF IFilters that will enable text searching for PDF files:
- Foxit PDF IFilter (commercial)
- TET PDF IFilter (free/commercial)
- Adobe PDF IFilter (32-bit / 64-bit) (free)
If you have issues with PDF text searching in Windows 10, this article has detailed instructions for resolving PDF IFilter issues:
https://fixedit.itxpress.biz/2018/07/05/searching-pdfs-in-windows-10/
- Published in Database & Retrieval, Export, Office PDF Text Processing
Will your SimpleQB allow me to scan in old invoices or bank statements directly into QuickBooks?
SimpleQB enables you to scan and link documents to QuickBooks transactions through a custom menu. When you have an invoice, purchase order, work order, bank reconciliation or other transaction open, simply click the Scan menu to scan a document and save it with that transaction.
To view the documents for a transaction, just click the View menu.
You can also use SimpleSearch to find and view documents scanned with SimpleQB without the QuickBooks interface.
- Published in Database & Retrieval, SimpleQB
Can SimpleQB be used to scan in receipts and invoices which are then matched to the files kept in the QuickBooks System?
Yes, That is exactly what SimpleQB was designed to do.
SimpleQB uses the information from your QuickBooks documents to file images under the appropriate customer/vendor, document type, document number and date. Simply pull up the corresponding file in QuickBooks and click scan!
- Published in SimpleQB
Is the document Search/Retrieval and View functions available in SimpleIndex or available only with the SimpleSearch add-on module?
All of the search functions can be used with any SimpleIndex license. SimpleSearch is only needed to enable searching from other workstations.
- Published in Database & Retrieval, Licensing & Installation
Does SimpleQB access or modify my QuickBooks database in any way?
SimpleQB does not make any changes to your QuickBooks database. When you scan documents with the SimpleQB interface, information about the current customer, vendor or document is passed to SimpleIndex for automatic indexing. When you view a document, the same information is used to find the corresponding scanned image.
- Published in SimpleQB
How do you configure full text searching in Retrieval mode?
On the Database tab there dropdown in the lower portion of the panel for Full Text OCR Field. Put the name of the field that will store the full-text data there. This must be configured both for Insert and Retrieval mode configurations. The database field needs to be sufficient length to store the entire text of your document.
Of course, the Insert Mode configuration must have “Enable Full Page OCR” checked to generate full text data from images. Text from MS Office documents, PDF files and existing OCR text files can be used without setting this option.
When designing your Retrieval Mode configuration, create a Text field to use for full text search queries. On the Database tab, set the corresponding “Database Field Name” to the full text database field.
When searching on your full text field, SimpleIndex finds the text you enter no matter where it appears in the document. It is able to match partial words. It does not perform boolean or natural language searches. The text entered must match the document text exactly.
- Published in Database & Retrieval, OCR
Affordable Document Management
SimpleIndex® is a great solution for small businesses and departments that need a quick and affordable way to scan, organize and view documents. SimpleIndex provides a wide variety of retrieval options, many of which require no special software to find and view documents.
The most affordable solution uses Windows folders and filenames to organize and find documents on a shared network drive. SimpleIndex lets you use index field values to create folders and filenames automatically, automating the process with barcodes, OCR and database lookups where possible. Other applications force the user to create folders and name files manually, making ad-hoc document management too labor-intensive to be practical.
You may also use SimpleIndex with SimpleSearch to create a keyword-searchable database that lets you find and view documents based on one or more index values. There are several advantages to using SimpleSearch instead of Windows folders:
- Find documents based on specific keywords or phrases
- Drop-down lists to select possible keyword values
- Use “And” and “Or” logic to search multiple field values
- Search the full text of OCR’d documents
- Search results are returned instantly
- Quickly browse through all matching files, even if they are in different folders
- Integrated file viewer with zoom, annotation, print and email functions
- Index data stored in a database and can be re-used for reporting and other applications
There are many ways to store and retrieve your documents using SimpleIndex. Click here to learn more about them.
Bringing Document Imaging to Everyone
The introduction of low-cost scanners and hard drive space has made many small businesses consider going digital with their documents. However, many find that the document management systems available are too complex and expensive to be practical in a small office. SimpleIndex was designed to solve this problem by removing many of the costly and cumbersome “gotchas” that make practical implementation of these systems impossible.
Here are some of the ways SimpleIndex saves you money:
- Standalone scanning, indexing & retrieval license starts at $500.
- Many companies offer affordable basic scanning solutions, but charge big for labor-saving features like barcode recognition and OCR that are necessary to make most scan jobs practical. SimpleIndex offers the complete package for $500.
- No limitations on processing volume (“click charges”).
- SimpleSearch provides a fully functional client/server document management system for minimal cost per workstation.
- Create searchable CDs or DVDs for document distribution with no additional modules to buy or royalties to pay.
- Files are stored in standard formats using logical folder and filename structures, allowing you to find documents without any special database or retrieval software just by browsing their folders. 20 years from now when no software exists that can read your document database, you will be glad you have this feature!
- SimpleIndex integrates with any custom database, allowing you to use existing infrastructure or free database formats instead of buying expensive database licenses for your imaging users. This also allows direct integration with your custom business applications with little or no programming.
- SimpleIndex integrates seamlessly with most document and content management systems available on the market today. Often this results in a much more streamlined input process for much lower cost than the interfaces provided with these systems.
- The labor required to scan documents has been a huge barrier for small businesses. SimpleIndex includes advanced template matching and dictionary matching OCR algorithms that let you extract index information from anywhere on a document, providing an unprecedented level of automation. Instead of calling this “Dynamic Forms Processing”and charging you an extra $10,000, we include this for free with our OCR module.
KB Articles for Document Management
- Oracle database is slow to respond
- What is Document Imaging?
- Using alternate database schemas
- Multiple Sort Fields on Search
- Access Database Connection String
- How do I delete an image and it's database entry?
- Is it possible to search for and retrieve documents with Windows desktop search?
- Will your SimpleQB allow me to scan in old invoices or bank statements directly into QuickBooks?
- How do I use the Media Wizard to create searchable DVDs or thumb drives?
- How do I export index data to a database?
SimpleInvoice Invoice Processing Solution
SimpleInvoice is a preconfigured solution that uses the OCR and dictionary matching functionality of the SimpleIndex scanning and indexing software to automatically scan, name, and organize incoming invoices into your chosen folder structure of searchable PDF files.
SimpleInvoice requires minimal configuration to get started. It comes with everything you need to index most common invoice styles. The customer and vendor lists, as well as your particular Purchase Order and Invoice number styles, can be customized for your company.
Use SimpleInvoice to:
- Automatically receive and enter invoices in your accounting software, especially QuickBooks
- Create full-text searchable invoice files
- Create an organized filing system for archiving invoices
- Quickly find specific invoices based on vendor, date, invoice number and other index fields
Please Contact Us to find out more about SimpleInvoice!
Templates, Not Training
Most data on an invoice matches common patterns like dates and total amounts. The one exception is the invoice number, which has a different format for every vendor.
Using the Template Autofill feature in SimpleIndex, you to spell out the specific OCR pattern of a vendor’s invoice number as a column in your Vendor database. When processing invoices, it first identifies the vendor, then searches for the matching pattern in the text to find the invoice number.
This solution is far simpler than the machine learning algorithms employed by enterprise invoice OCR systems, which is why SimpleIndex is a fraction of the cost. It’s also simpler than other template-based systems that require you to locate every field for every vendor.
However if you require line item capture, PO matching, approval workflows, or have thousands of vendors to process, then an enterprise invoice processing solution is more appropriate.
FAQ Related to Invoice Processing
- Regular Expression (RegEx) - Syntax or Type
- Will your SimpleQB allow me to scan in old invoices or bank statements directly into QuickBooks?
- Is there a way to just use part of a bar code or OCR value? For example, extract "50" from the value "124450"
- Can SimpleQB be used to scan in receipts and invoices which are then matched to the files kept in the QuickBooks System?
- How do you train the OCR engine for better accuracy?
Video Demos
These videos demonstrate several ways SimpleIndex® can automatically index different types of documents. If you are new to SimpleIndex, watching these videos is the easiest way to see what it can do. You can follow along using the sample files included in the SimpleIndex Trial.
- Zone OCR with template matching
- Document barcode recognition
- PDF OCR text parsing
- Sort and index MS Office documents
- Indexing with full-text OCR
- Running jobs from an icon
The sample files are copied to your Configuration Folder when you run the SimpleIndex Trial for the first time. If you can’t find the samples, copy them with the Global Settings Wizard in the File menu.
Compare Major Scanning Solutions
Integrated Solutions Built with SimpleIndex
Zone OCR with Template Matching
Document Barcode Recognition
PDF OCR Text Parsing
Sort and Index MS Office Documents
Full Page OCR Invoice Processing
KB Articles for Optical Character Recognition
- Language Pack for Standard/Tesseract OCR
- Languages Supported in SimpleSoftware OCR Engines
- What is Document Imaging?
- Change the Dictionary Separator Value
- Change the OCR Font or Type
- Regular Expression (RegEx) - Syntax or Type
- Autonumber Increment Value
- I'm using full page OCR. The information is all appearing in the txt file but it is losing format about half way through. Data to the right is ending up at the end of the txt doc. Can this be fixed?
- Is there a way to just use part of a bar code or OCR value? For example, extract "50" from the value "124450"
- If I have a form which is filled manually by hand, can SimpleIndex read the data from it?
Document Management
Designing Your Document Management Solution
If you have not yet decided on a plan for how to organize your scanned images for later retrieval, you should take some time to consider the possible options. There are several ways to search and view documents scanned with SimpleIndex®:
- Use SimpleSearch to use keyword searches to find and view indexed documents
- Use SimpleView to browse folders, search files, view, edit and annotate scanned documents without a database
- Use a third-party document management system for integrated searching, viewing, workflow, HIPAA compliance and other document-centric functions
- Use SharePoint to share documents online, create custom document workflows and employ records management standards
- Use the Windows Search Bar to search the names AND contents of files stored on Windows Server 2008 or later.
- Integrate SimpleIndex directly with your custom application using the Command Line Interface
- Work with our professional services team or an Authorized Dealer to create a customized solution or direct integration with virtually any application
- Use a custom database or spreadsheet such as MS Access, SQL Server or Excel to store the index data and provide links to the stored document images
Use SimpleSearch
SimpleSearch is included with all versions of SimpleIndex and can also be licensed by itself. SimpleSearch implements the same SimpleIndex interface in “Retrieval” mode, hiding all the menus and toolbars used for scanning. Index fields normally used to assign values are used for searching instead.
SimpleSearch can use SimpleIndex‘s built-in database to perform searches, or connect to any other database, even those for existing business applications. Users simply type index values they want to find and SimpleIndex displays the matches. Partial matching and full text searches are also supported. Displayed documents can be printed, e-mailed or opened in their associated application (Word, Adobe Reader, Excel, etc.). SimpleSearch can view several common image formats, PDF files and can preview files for any OLE-enabled application installed on your computer (MS Office, Adobe applications, AutoCad, etc.)
Using a Document Management System
There are a wide variety of small business and enterprise document management systems available on the market today. They manage stored images and index data, and provide users an interface to search for and view these images. Many perform advanced functions like workflow management, revision tracking and access auditing for HIPAA compliance. SimpleIndex has the ability to interface with these systems, making it an ideal scanning front-end for use with most document management systems on the market.
Integration with document management software is done via the Index Log Files that SimpleIndex creates. Documents are scanned and indexed with SimpleIndex, and a log file is created that lists each image scanned and the index information associated with it. Virtually all document management systems come with standard or optional components that allow you to automatically import images and index information in the format SimpleIndex provides.
Many document management systems have a scanning module that is sold separately, at significantly greater cost than SimpleIndex. With a single scanner, SimpleIndex can provide an easier and more cost-effective scanning interface than the default module. With multiple scanners, the low cost of SimpleIndex makes it possible to implement Distributed Document Capture for a fraction of what it would cost otherwise.
Use the Windows Search Bar
On Windows Server 2008 or later you can enable Windows Search Service and the indexing options that come with it to quickly find your files using the search in the top corner of your Explorer window. Once Windows Search is setup on the server, on your local PC simply pick any shared drive or folder that you would like to rapidly search and add it to a library. When you type a word or phrase in the search bar Windows will search not only all the file names but the content of the files as well. More information on setting up the search capability on Windows Server can be found here.
KB Articles for Document Management
- Oracle database is slow to respond
- What is Document Imaging?
- Using alternate database schemas
- Multiple Sort Fields on Search
- Access Database Connection String
- How do I delete an image and it's database entry?
- Is it possible to search for and retrieve documents with Windows desktop search?
- Will your SimpleQB allow me to scan in old invoices or bank statements directly into QuickBooks?
- How do I use the Media Wizard to create searchable DVDs or thumb drives?
- How do I export index data to a database?