Outgoing Invoices: Excel Export, Receipts, DATEV CSV and Direct

Exports & Accounting

Excel Export & Receipts | Accounting Export | Transmission

Excel Export & Receipts

There is a straightforward export option for invoice data and receipts. For accounting purposes, we recommend the accounting export (topic to follow).

Export Invoices (XLS & Receipts)

Under "Invoicing" > "Invoices", you can export the pre-filtered invoices (select the desired status using the icons when filtering) as Excel in the top right corner or download the invoice receipts collectively.

The Excel export "Individual Items" includes comprehensive data – including utilised service categories and cost centres. Learn more about defining categories and cost centres

Sammeldownload Rechnungs PDFs Agentursoftware MOCO(English image not yet available)

Export Payments

Under "Invoicing" > "Payments" you can 
  • Export payments as Excel.
  • Export invoice receipts by payment date.
For cash accounting (the payment date is applicable, not the invoice date)

Export Invoices for Cash Accounting 

For cash accounting, the payment date is applicable, not the invoice date, for tax calculation.
Use this export under "Invoicing" > "Invoices" as well. Filter the invoices from the relevant period and export as Excel. In Excel, filter by the "Paid on" column to get the tax sum for the desired period.

Accounting Export

Invoicing > Accounting

Using Accounting Export Without Pre-Allocation

Utilise the accounting export even if you're not optimising for a specific accounting system. This way, you can benefit from all the advantages:
  • Ignored cancellation invoices and cancelled invoices are automatically offered (these do not play a role in debtor management under "Invoices", which is why they are excluded from standard filtering).
  • You always know which invoices have not yet been exported for accounting
  • You can decide to what extent you want to pre-allocate

MOCO bridges the gap to accounting with its accounting section. Outgoing invoices can be pre-allocated and transmitted to accounting. This not only enables synchronous management of accounting & MOCO but also reduces effort and costs in accounting.
▶️ Tobias from MOCO introduces the activatable accounting in this video.

Activating the Accounting Section

After selecting an accounting option in the settings, the additional sub-item "Accounting" (1) is available under "Invoicing" (similarly under "Expenditures"). Before an export is carried out, the accounts should be set up. 
» All information on activation and accounting accounts

Review and Edit in the Invoice List

MOCO offers all invoices for accounting export under "Accounting".

Typically, you export monthly and proceed as follows:
1.
Check debtor (debtor account) and revenue (counter account/revenue account) in the list
2. Select invoices for export
3. Create the export using the "Export Invoices" button at the bottom right.
Exported invoices are automatically locked and cannot be selected for export a second time.

Using Labels
The labels, with which invoices have been marked or categorised, are also available in the accounting section (filtering in the side menu + in manual export).

Status Ignored/Handling of Cancellation Invoices
The status "Ignored" can include cancelled invoices and cancellation invoices, as MOCO automatically sets these invoices to cancelled if no payment has been recorded. 
If an invoice is immediately cancelled (instead of being deleted), then this + cancellation invoice could be ignored for export. 

Kontierung und Buchhaltungstransfer Ausgangsrechnungen(English image not yet available)

Debtors & Revenue Accounts

  • Debtor account and revenue account can be directly overwritten here in the list by double-clicking. 
  • All debtors can be managed in the "Accounts" tab. » More about Debtors
  • You can define revenue accounts at the service level or invoice level » More about Revenue Accounts
  • In addition to revenue accounts, categories and cost centres can also be transmitted to DATEV

Exports

Under the "Exports" tab, all exports are listed with the specified period. The outgoing invoices belonging to the export are listed and linked by clicking on the export.

Transmission

Depending on the chosen accounting option, the transmission of invoice data and receipts to accounting/tax consulting is done manually or via direct transfer:

Manual

Generic CSV export, DATEV CSV format, etc. Find all accounting export options here
The created CSV export is listed under "Exports" with the specified period and is made available to the tax consultant (e.g., monthly) along with the collectively downloaded receipts.

Custom fields on the invoice (single choice & single line text input) are included in the generic CSV export.

Direct Transfer

DATEV Unternehmen online (DUO)
Invoice data including receipts are directly transferred to DATEV Unternehmen online with a click during the export process. After provision, the tax consultant can retrieve and further process the data as booking suggestions.

datev export bestätigen(English image not yet available)
datev export erfolgreich(English image not yet available)
Assistance with error messages

Delete Exports

You can track which invoices have been exported in the detail view. CSV exports can be deleted by all authorized users within 24 hours, later only by the account holder. Exports to DATEV Unternehmen online can only be deleted by the account holder.

Mehr zu Abrechnung...
Try for free for 30 days

Account ready to go immediately. No payment details required.