The interaction between DBA and the outside accounting system is managed here on the Financial Transfer menu. All financial data are transferred in a one-way direction, from DBA to the outside system.
Our Financial Transfer design enables each system to do what it does best, with no duplicate or overlapping functions. Sales, work in process, purchasing, and inventory are handled exclusively by DBA. Receivables, payables, banking, payroll, and overall financial reporting are handled exclusively by the outside accounting system.
Only 13 general ledger accounts, plus any extra sales and cost of goods sold accounts you choose to add, are common to the two systems. These accounts are cross-reference on this screen.
Sales orders create the demand that drives the manufacturing system. Order picking relieves inventory and generates the invoices that are sent to customers.
The AR Invoice Transfer screen is used to transfer each day's invoices, credit memos, and new customer records to the outside accounting system for receivables processing.
Each transfer invoice includes complete header detail, but only a single line item for the invoice total amount. Line item detail remains in the DBA invoice and is the basis for a wide array of sales reports and data views.
Invoices are transferred by clicking the Output button to generate a spreadsheet or text file that will be imported into the outside system. Here we are looking at our invoices in a comma-separated text file format.
Supplier invoices are matched with purchase orders in DBA.
The PO Invoice Transfer screen is used to transfer each day's supplier invoices, credit memos, and new supplier records to the outside accounting system for payables processing.
Each transfer invoice includes complete header detail, but only a single line for the invoice total amount.
The Output button is used to generate a spreadsheet or text file that will be imported into the outside system.
At period end, the GL Transfer screen is used to transfer DBA account totals to the outside accounting system.
GL transactions are summarized into a single debit and credit amount per account that get cross-referenced and transferred to the outside general ledger by means of a batch journal entry. All transaction detail remains in DBA for a complete audit trail.
As with the other transfers, the Output button is used to generate a spreadsheet or text file that will be imported into the outside system.
If you are using QuickBooks, our Financial Transfer can be used with the Transaction Pro Importer utility for QuickBooks, which is published by Baystate Consulting. This import utility works with all QuickBooks editions as well as the USA, Canada, UK, and Australia versions.
Also, keep in mind that with QuickBooks you can use the less expensive Pro edition because the advanced sales and inventory features that come with the more expensive Premier and Enterprise editions are handled by DBA and are not needed.