Accounting consultant with statistics

This course will introduce you to all the important areas of accounting. You will be taught basic theoretical knowledge of financial and balance sheet accounting and controlling as well as how to use the DATEV software for the relevant specialist areas. You will also gain an insight into a statistical program in order to prepare data, identify correlations, verify observations and correctly classify measurement data.

 

In this course, you will work practically with the on-premise programs of DATEV eG; selected content from the DATEV Students online learning platform will also be integrated to deepen your knowledge.

  • Certificates: Certificate "Accounting Consultant"
  • Additional Certificates: Certificate "Fundamentals of Accounting"
    DATEV certificate "DATEV financial accounting user"
    DATEV training partner certificate of attendance
    Certificate "Fundamentals of Controlling"
    Certificate "Controlling practice with DATEV"
    Certificate "Balance sheet accounting with DATEV"
    Certificate "Statistics and data analysis"
  • Examination: Praxisbezogene Projektarbeiten mit Abschlusspräsentationen
    DATEV-Anwender Finanzbuchführung (Eine Anmeldung über das Lernportal „DATEV Students online“ ist für die Zertifizierungsvorbereitung obligatorisch.)
  • Teaching Times: Full-time
    Monday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
  • Language of Instruction: German
  • Duration: 24 Weeks

Accounting basics

Accounting basics (full-time approx. 2.5 days/part-time approx. 5 days)

Legal basics

Inventory, stocktaking, balance sheet

Document organization

Land register, general ledger, sub-ledgers

Chart of accounts and chart of accounts

Tasks and structure of the chart of accounts


Artificial intelligence (AI) in accounting (full-time approx. 0.5 days/part-time approx. 1 day)

AI as a digital assistant in commercial processes

Possible applications and limits of AI in accounting


Posting to inventory and profit and loss accounts (full-time approx. 5 days/part-time approx. 10 days)

Effects of inventory changes and business transactions on balance sheet items

Breakdown of the balance sheet into balance sheet accounts

Posting business transactions and closing balance sheet accounts

Simple and compound posting record

Opening and closing balance sheet account

Expenses and income

Profit and loss account as closing account of the profit and loss accounts


Introduction to the depreciation of depreciable assets (full-time approx. 0.5 days/part-time approx. 1 day)

Causes, effects, calculation and posting of depreciation

Effects on P&L and annual profit


Value added tax on purchases and sales (full-time approx. 1 day/part-time approx. 2 days)

Nature of sales tax (value added tax)

Value added tax as a transitory item

Accounting for sales tax and input tax


Private withdrawals and deposits (full-time approx. 1 day/part-time approx. 2 days)

Private withdrawals and private deposits at a glance

Postings via the private account

Closing the private account


Procurement and sales bookings (full-time approx. 3 days/part-time approx. 6 days)

Merchandise

Procurement costs, distribution costs

Returns, credit notes

Rebates, discounts and bonuses


Posting of selected business transactions (full-time approx. 2 days/part-time approx. 4 days)

Basics of open item accounting

Postings in the personnel area

Postings in the tangible assets area

Postings in the tax area


Year-end closing (full-time approx. 1.5 days/part-time approx. 3 days)

Preparatory closing entries

Posting inventory differences

Accrual of expenses and income


Project work (full-time approx. 3 days/part-time approx. 6 days)

To consolidate the content learned

Presentation of the project results

Financial accounting with DATEV

Client master data (full-time approx. 1 day/part-time approx. 2 days)

Creation of a new client

Importing, saving and managing client data


Account master data (full-time approx. 3 days/part-time approx. 6 days)

From chart of accounts to chart of accounts

Account functions

Creating individual accounts

Creating and managing current accounts

Account assignment of sample documents according to SKR03 or SKR04


Posting (full-time approx. 6 days/part-time approx. 12 days)

Posting according to the DATEV posting logic

Posting digital documents

Posting with automatic accounts and tax keys

Working with posting batches, batch management and fixing

Dialog postings and batch postings

Allocation and split postings

Reversal postings / general reversal in DATEV

Posting intra-community deliveries and acquisitions

Posting for third country transactions

Posting by company code (incoming and outgoing invoices, bank, cash register)

Posting lists and error control

Overview of the invoice automation service (ASR) and bank automation service (ASB)


Financial accounting evaluations (full-time approx. 2 days/part-time 4 days)

Primanota and journal

Totals and balances list

Open item management (posting invoices and payments, OP clearing)

Advance sales tax return

Small business regulation (§ 19 UStG) and special reporting procedure (§ 19a UStG)

Summary report (ZM)

Business analyses (BWA)

Controlling report

AI-supported analysis of evaluations


Year-end closing (full-time approx. 3 days/part-time approx. 6 days)

Closing entries

Balance sheet and profit and loss account

Statement of fixed assets

Annual financial statement evaluations

Printing and providing evaluations

Depreciation options: declining balance depreciation, special depreciation rules for electric vehicles

AI-supported preparation, documentation and quality assurance in the annual financial statement process


Special features (full-time approx. 1 day/part-time approx. 2 days)

Integration with wages and salaries

Integration with asset accounting (ANLAG)

Interfaces and data transfer


Digital collaboration between law firm and client (full-time approx. 1 day/part-time approx. 2 days)

Overview of DATEV Unternehmen online in financial accounting

Setting up document posting

Posting digital receipts and posting payments

Evaluations in accounting

Overview of e-invoicing (ASR and ASB)

MyDATEV Kanzlei at a glance


Project work, certification preparation (via the DATEV Students online platform) and certification exam "DATEV-Anwender Finanzbuchführung" (full-time approx. 3 days/part-time approx. 6 days)

Controlling basics

Introduction to controlling (approx. 1.5 days)

Controlling as part of the management process

Overview of the various controlling instruments and methods

Strategic and operational controlling


Cost accounting and cost management (approx. 3.5 days)

Introduction to cost and activity accounting

Cost element accounting

Cost center accounting

Cost unit accounting


Cost accounting systems (approx. 3 days)

Actual, normal and planned cost accounting

Partial and full cost accounting

Activity-based costing


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Corporate planning and budgeting (approx. 4 days)

budget planning

Liquidity planning

investment planning


Key figures and key figure systems (approx. 3 days)

Contribution margin

Balanced scorecard


Reporting (approx. 2 days)

reporting

BWA

Data protection in controlling


Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results

Controlling practice with DATEV

Cost accounting with DATEV (approx. 7 days)

Creation of basic data

Creation of the cost center plan

Structure of the evaluations

Adaptation of cost accounting to operational requirements

Account allocations

Internal activity allocations and apportionments

Entering and processing batches

Displaying and printing evaluations

Setting up evaluation packages


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Business planning with DATEV (approx. 5 days)

Overview and functionality of DATEV

Basics of planning calculation

Planning strategies - setting up a planning and control system with integrated profit and liquidity planning

General planning approaches

Detailed planning options using detailed objects

Investment planning (investment and financing)

Program links

Target/actual comparison and DATEV controlling report

Evaluations: Brief overview and standard evaluations as well as planning report


Analysis and planning in accounting (approx. 5 days)

The monthly analysis

Profit analysis: comparison with previous year, target/actual comparison, industry comparison, time series presentation for trend statements

Liquidity analysis: static liquidity, withdrawal behavior, payment habits, account management, cash flow statement with cash flow calculation

Use and origin of funds

Special solutions and occasions

Determination of debt servicing capacity

Individual BWA (adaptation of the standard BWA)


Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results

Balance sheet accounting with DATEV

Current framework conditions for accounting and closing processes (approx. 2 days)

Legal basis of accounting

Size classes, disclosure and publicity

Preparation, adoption and audit of the annual financial statements

Current developments in legislation, DRS, IDW pronouncements

Going concern, estimation uncertainties and reporting

Classification of sustainability reporting (CSRD/ESRS) for accounting and reporting


Commercial balance sheet, tax balance sheet and deferred taxes (approx. 1 day)

Differences between commercial and tax balance sheets

Applicability and deviations

Deferred taxes

Documentation of accounting and valuation decisions


National accounting in accordance with HGB (approx. 6 days)

Accounting and valuation principles

Accounting of assets and liabilities (fixed assets, current assets, equity and liabilities)

Income statement, notes and management report

Options and valuation options

Case studies on HGB accounting

AI-supported plausibility check of financial statement data, key figures and disclosures in the notes


Year-end closing and reporting with DATEV (approx. 4 days)

Preparation and posting of financial statements

Reconciliation/valuation of fixed assets

Working with evaluations in accounting

Balance sheet report and company report in DATEV

Analyzing financial statement evaluations and reporting to the right audience

Quality assurance in the digital closing process

AI-supported interpretation of DATEV evaluations and creation of draft reports


Introduction to international accounting in accordance with IFRS (approx. 4 days)

Objectives and areas of application of IFRS

Advantages compared to national accounting

Differences between HGB and IFRS

Components and presentation of annual financial statements according to IFRS

Valuation approaches according to IFRS (cost model/fair value model)

Selected accounting fields: Property, plant and equipment, intangible assets, provisions and leasing

Principles of classification according to IFRS

Overview of segment reporting, cash flow statement and statement of comprehensive income

Evaluation and interpretation of IFRS financial statements


Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results

Statistics and data analysis

Statistical basics (approx. 6 days)

Measurement theory basics (population, sample, sample types, measurement, scale levels)

Univariate descriptive statistics (frequency distributions, central measures, measures of dispersion, standardization, histograms, bar charts, pie charts, line charts, box plots)

Bivariate descriptive statistics (measures of correlation, correlation coefficients, crosstabs, scatter plots, grouped bar charts)

Basics of inductive inferential statistics (probability distributions, normal distribution, sampling distribution of the mean, significance test, null hypothesis test, significance level, effect size, parameter estimation, confidence intervals, error bar charts, power analysis, sample size)

Data preparation and data cleansing with suitable software

Descriptive analysis

Visualization of statistical results

AI-supported analysis and interpretation of statistical results


Methods for comparing two groups (approx. 5 days)

z-test, t-test for one sample

t-test for independent and related samples

Pretest-posttest designs with two groups

Supporting significance tests (Anderson-Darling test, Ryan-Joiner test, Levene test, Bonett test, significance test for correlations)

Nonparametric methods (Wilcoxon test, sign test, Mann-Whitney test)

Contingency analyses (binomial test, Fisher's exact test, chi-square test, cross-tabulations, measures of association)

Interpretation of test results

AI-supported interpretation of results


Basics of regression analysis (approx. 2 days)

Linear regression

Model interpretation

AI-supported model interpretation

Correlation analysis


Methods for comparing the means of several groups (approx. 3 days)

One-factorial and two-factorial analysis of variance (ANOVA)

Post-hoc analyses

Interpretation of group differences

Multi-factorial analysis of variance (general linear model)

Fixed, random, crossed and nested factors

Multiple comparison methods (Tukey-HSD, Dunnett, Games-Howell)

Interaction analysis

Power analysis for variance analyses


Introduction to Design of Experiments (DoE) (approx. 1 day)

Full factorial and partial factorial experimental designs


Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results



Changes are possible, the course content is updated regularly.

After the course, you will be able to competently take over the organization of operational finance and accounting. You will be proficient in using the DATEV program and also have the necessary specialist knowledge to strategically plan, monitor and optimize performance processes in the company.

You will also understand the basics of statistics, be able to process and evaluate data and present, explain and interpret statistical data analyses and results using graphics.

The course is aimed at employees from corporate finance and accounting, specialists from tax consulting and auditing firms and from controlling.

As an accounting officer, you will support and advise the management, reconcile internal and external processes and act as a competent point of contact for external partners such as auditors. This opens up a wide range of career prospects for you in all sectors, especially in larger companies where you can support group accounting in the future.

A sound knowledge of statistics is a valuable additional qualification that is in great demand in industrial research and development, in drug development, in the supervision of medical studies, in finance and insurance, in information technology or in public administration.

Your meaningful certificate provides a detailed insight into the qualifications you have acquired and improves your career prospects.

Didactic concept

Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).

You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.

 

Virtual classroom alfaview®

Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face lessons via video technology.

 

The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).

We will gladly advise you free of charge.

0800 3456-500 Mon. - Fri. from 8 am to 5 pm
free of charge from all German networks.

Contact

We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm free of charge from all German networks.