Accounting: basics, applications with DATEV and knowledge of Excel
Free of cost
by funding
-
Certificates: Microsoft Excel" certificate
Certificate "Fundamentals of Accounting"
DATEV certificate "DATEV financial accounting user"
DATEV training partner certificate of attendance -
Examination: Practical project work with final presentations
Module examination Microsoft Excel
DATEV user financial accounting -
Teaching Times: Full-time / Part-timeFull-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.). Part-time: Monday to Friday from 8:30 a.m. to 11:45 a.m. (in weeks with public holidays from 8:30 a.m. to 12:35 p.m.).
-
Language of Instruction: German
-
Duration: 10 Weeks full-time / 20 Weeks part-time
Spreadsheet calculation with Microsoft Excel
Spreadsheet calculation with Excel (full-time 10 days/part-time 20 days)
Basics of table editing
Working with formulas and functions
Formatting cells, editing and printing tables
Filling, moving and copying
Calculating with date and time
Creating and editing diagrams
Using individual print settings
Manage workbooks
Using chart templates and chart layouts
Using Excel templates
Sorting and filtering data
Accounting basics
Accounting basics (full-time approx. 1.5 days/part-time approx. 3 days)
Legal basics
Inventory, stocktaking, balance sheet
Determination of profit through equity comparison
Posting to balance sheet and profit and loss accounts (full-time approx. 2 days/part-time approx. 4 days)
Value changes in the balance sheet
Dissolution of the balance sheet in inventory costs
Posting business transactions and closing balance sheet accounts
Simple and compound posting records
Opening and closing balance sheet account
Expenses and income
Profit and loss account as closing account of the profit and loss accounts
Introduction to depreciation of property, plant and equipment (full-time approx. 0.5 days/part-time approx. 1 day)
Causes, posting and effect of depreciation
Calculation of depreciation
Profit and loss account
Change in inventories of finished goods and work in progress (full-time approx. 1 day/part-time approx. 2 days)
Inventory increase, inventory decrease
Effect on the profit and loss account
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Value added tax on purchases and sales (full-time approx. 1 day/part-time approx. 2 days)
The nature of sales tax (value added tax)
Value added tax - a transitory item for companies
Accounting for sales tax
Private withdrawals and deposits (full-time approx. 1 day/part-time approx. 2 days)
Private account
Free withdrawal of goods and other services
Organization of bookkeeping (full-time approx. 3 days/part-time approx. 6 days)
Chart of accounts
Tasks and structure of the chart of accounts
Chart of accounts and chart of accounts
Document organization
Meaning and types of documents
The books of financial accounting
Basic ledger, general ledger
Overview of the subledgers
Overview of common accounting programs
Master data maintenance
Open item accounting
Commercial arithmetic: Rule of three, calculating percentages, calculating interest
Bookings in the personnel area (full-time approx. 1 day/part-time approx. 2 days)
Wages, salaries
Advances, benefits in kind
Special allowances
Procurement and sales bookings (full-time approx. 3 days/part-time approx. 6 days)
Merchandise
Procurement costs, returns
Immediate discounts, price reductions
Delivery accounts, customer accounts
Posting of material purchases to expense accounts
Bookings in the fixed assets area (full-time approx. 0.5 days/part-time approx. 1 day)
Asset accounting
Acquisition of fixed assets
Retirement, sale, withdrawal of fixed assets
Taxation of companies and entrepreneurs (full-time approx. 0.5 days/part-time approx. 1 day)
Annual financial statements (full-time approx. 2 days/part-time approx. 4 days)
Inventory differences
Other receivables/other liabilities
Prepaid expenses and deferred income
Provisions/valuation of receivables
Closing in the main financial statement overview
Cost and activity accounting (full-time approx. 1 day/part-time approx. 2 days)
Tasks of cost and performance accounting
Basic concepts of KLR
Expenses - Income
Expenses - costs
Income - services
Imputed costs, tasks and types
Project work (full-time approx. 2 days/part-time approx. 4 days)
To consolidate the content learned
Presentation of the project results
Financial accounting with DATEV
Client master data (full-time approx. 1.5 days/part-time approx. 3 days)
Creation of a new client
Importing and saving 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 the SKR03 or SKR04 chart of accounts
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Posting (full-time approx. 6 days/part-time approx. 12 days)
According to the DATEV posting logic
Posting with automatic accounts and tax keys
Posting with "posting batches"
Defining "posting batches"
Dialog postings and batch postings
Allocation and split postings
Reversal postings - general reversal (DATEV)
Posting intra-Community deliveries and intra-Community acquisitions
Posting for third country transactions
Posting by company code (incoming and outgoing invoices, bank, cash register)
Posting lists
Financial accounting evaluations (full-time approx. 2 days/part-time approx. 6 days)
Primanota and journal
Totals and balances list
Open item management (posting invoices, posting payments)
Advance sales tax returns
Summary reports (ZM)
Business analyses (BWA)
Controlling report
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 evaluations
Special features (full-time approx. 1.5 days/part-time approx. 3 days)
Integration with the wage and salary program
Integration with asset accounting (ANLAG)
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)
Changes are possible. The course content is updated regularly.
You understand the concept of spreadsheets and master the use of Excel quickly and confidently in order to achieve optimal and accurate work results.
The course then provides an introduction to bookkeeping. You will master the competent handling of accounting processes. Everything is considered and explained in a practical way and in the context of the overall business operations of a company.
You will also receive a systematic introduction to basic data processing in accounting with the DATEV program. After the course, you will be able to deal competently with accounting processes.
The course is aimed at people with little or outdated commercial knowledge who want to reorient themselves in the field of accounting or refresh their accounting knowledge.
Knowledge in the use of various MS Office programs is a prerequisite for successful and efficient work in professional life.
Employees with a sound basic knowledge of accounting are indispensable in today's working world and are in demand in companies of all sizes across all industries.
The addition of DATEV financial software will also improve your prospects on the job market: according to the manufacturer, around 2.5 million medium-sized German companies rely on DATEV's information services.
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).