Dividing Up Incoming A/P Invoices into Multiple Accounts: The GL Coding Dialog

Accounts | Anota | Invoices

It’s simple to split invoices to reflect multiple cost centers in DocuWare. It saves you from entering tons of annoying data into your ERP. The splitting tool also lets you generate ERP-compatible data records without much effort.

In an ERP, only verified invoices should be saved that have been clearly identified for payment. It is therefore incredibly useful to verify documents as soon as they are received in DocuWare and distribute the total amount into the corresponding accounts. The easiest way to do this is by using a workflow for incoming invoices, because much of the required data has already been collected and is available for comparison.
To split an invoice amount into different accounts, you use a specially designed tool known as the GL coding dialog. Your DocuWare system then creates records that are compatible with all current ERP systems. The data is simply transferred into your accounting system and stored.

How Companies Work with GL Coding Dialog
The German company OptaData has been successfully using the GL coding dialog for a long time. All incoming invoices are first scanned by the accounting department and tagged with DocuWare‘s Intelligent Indexing. The system assigns the invoices accordingly and stores them in the central document pool. Authorized users can now access the documents via ERP or DocuWare.
The storage process then triggers a workflow for verifying and approving each invoice at OptaData. An invoice appears in the task list of the accounting staffer designated for account assignment. The total amount of the invoice is then split into subtotals and assigned to each respective cost center. A colleague verifies this and confirms everything with a digital stamp. Invoices are then automatically transferred to the cost center managers of the various departments.
They check them using the GL coding dialog, which is attached to the invoice, and approve their respective partial amount by stamp. Once all approvals are granted, the invoice appears again in the accounting department - now with the request "Pay Invoice."

5 Steps to Data Export
The following example shows the GL coding dialog. Intelligent Indexing was used for this, so the service learned (and keeps learning) all it needs to know about various suppliers.


1. First, you create the invoice record as usual:

Splitting Tool Sreenshot 1 EN

2. Then you enter it as a worfklow task:

Splitting Tool Sreenshot 2 EN

3. In the special GL coding dialog you can assign the invoice to various accounts:

Splitting Tool Sreenshot 3 EN

In the top part you’ll find all the general information about the invoice and vendor. The table below can be easily created by adding rows and selecting or entering values. In most cases, the counter-account is assigned to a single supplier, the invoice issuer.

4. A corresponding account assignment sheet is added:

Splitting Tool Sreenshot 4 EN

5. The data records are then exported to your ERP solution, in this example it uses a CSV format:

Splitting Tool Sreenshot 5 6 EN

Where Can I Find This?
If you are interested in the split invoicing tool, please contact your DocuWare Partner or the DocuWare sales team. This cost-effective tool can be tailored to your individual needs with DocuWare Professional Services support.
For this function to be set up in your DocuWare system, you‘ll need a license for Workflow Manager. We also recommend Intelligent Indexing, which saves you from manual data input.

Subscribe

Subscribe to our email newsletter so you can stay up-to-date with insights and how-to’s from our experts.

Please let us know your email address.

Document Management

  • Market Leading Software
  • Simple to Use
  • In-house or Cloud based
  • Dedicated Mobile App
  • Automated Workflow Approvals
  • Integrate into your existing ERP
  • Fully Compliant with Audit Trail
  • Version Control

Read More

Does Your Copier Do This?

  • Automatically index and file during printing
  • Approve invoices digitally
  • Scan any document into a digital workflow process
  • Distribute post electronically for more efficient workflow
  • Ongoing print reduction review process

Read More

Consultancy Services

anota logo
  • Requirements Analysis
  • Project Management
  • Specification and Design
  • Process Mapping
  • Configuration and Development
  • Implementing, Testing and Training
  • Support

Read More

Contact Us

Please enter your details below, if you have an enquiry or would like us to give you a call back.

Head Office

5 Carrwood Park, Selby Rd, Leeds LS15 4LG
Tel: 0113 887 2400

Please let us know your name.
Invalid Input
Please let us know your email address.
Invalid Input
Please let us know your message.
*Required Fields