SimpleQB also lets you automatically link scanned documents or network files to QuickBooks transactions.

SimpleQB - QuickBooks data integration

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 s
Read more
No Comments

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.

Read more
No Comments

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/

Read more
No Comments

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.

Read more
No Comments

Is there a way to just use part of a bar code or OCR value? For example, extract “50” from the value “124450”

To do this example, create a barcode field (Field 1 for example) and a 2nd field with type “Fixed”. In the template for the 2nd field, enter %FIELD1[5,2]% to get “50” from “124450”.

%FIELD1% would get the entire value for Field #1, the barcode field. By adding the [5,2] you tell SimpleIndex to start at the 5th character (5) and take 2 characters from the value (50).

Find out more about barcode scanning on our Barcode Scanning Guide and read up on Optical Character Recognition on the SimpleOCR scanning solutions guide.

Read more
No Comments

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!

Read more
No Comments

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.

Read more
No Comments

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.

Read more
No Comments

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 search

Read more
No Comments

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 phr

Read more
No Comments

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! [video width="1280" height="692" mp4="https://www.simpleindex.com/wp-content/uploads/2020/03/SimpleInvoi
Read more
No Comments

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 Compare the SimpleIndex scanning and indexing workflow to 4 leading desktop document imaging applications–Kofax Express™, Kodak Capture Pro™, PaperVision™ Capture Express and Office Gemini DiamondVision™. Compare SimpleIndex to the competition University of SimpleSoftware Extensive online training vid
Read more
No Comments

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 crea
Read more
No Comments