WINLine Financial Accounting Basis Seminar Agenda WINLine ACC
WINLine Financial Accounting Basis Seminar
Agenda • WINLine ACC 1 • Base Info (AR/AP accounts, GL accounts, Tax lines, Payment terms, Foreign Currencies) • Data Entry Posting programs (Posting Real Time Batch, Cash Account, Void Postings, . . . ) Invoice Reconciliation Invoice Modification • Examples for all important points
Agenda • WINLine ACC 1 • Data Entry Payment Transactions (Clearing, . . . ) Payment Reconciliation Event Plan Past Due Reminders • Reports • Yearly Closing procedures Examples for all important points
Execution plan: Implementation Setup • Company Base Info • Tax rates (lines) • Financial Statement Codes (FSC) • Payment terms • Account Base Info (AR/AP and GL) • Posting Types • Past Due Parameters
Execution plan: Implementation Setup • Press Company Info • Print FSC Info • Print Chart of Accounts • Edit Reports (e. g. , Past Due Reminders, Payment Transaction, etc. )
Company Base Info • Link to Fiscal Year (set up periods) • UID Number • Fiscal Year boundaries • Current Posting Period (Warning in posting programs) • 2 Local Currencies • Currency rates relate to EURO
VAT Locking • Manual locking of Periods • Release using Authorization Profiles • Display of completed lines • Display of incomplete lines
Company Base Info • Any number of tax rates (lines) • Definition of automatic posting account for posting of tax and discount calculations • Acquisition Tax checkbox (input tax) • Flexible positioning of the tax line in the VAT Reporting form • Tax classes • Tax groups
Company Base Info • 3 x 0 %, 10 % and 20 % (separate discounting for assets, goods, other) • Acquisition tax (checkbox) • Import tax on turnovers • Revenue in other EU region (for Summary Report) • Third-country revenues • Various lines for applicable taxes in EU countries
Financial Statement Codes (FSC) • • Separation for balance sheet and income statement 5 levels + Account level 1000 - 1999 for asset account totals 2000 - 2999 for liability account totals 3000 - 3999 for expense account totals 4000 - 4999 for income account totals Optional page breaks and sub-totaling Text notes and budgeting
Example of FSC Levels 1000 A. ASSETS Level 1 1010 I. INTANGIBLE ASSETS 1020 1. Concessions, Trademarks, etc. 0120 Software 1050 II. Physical Assets 1060 1. Developed Real Estate Level 3 0200 Developed Land Level 2 0210 Buildings 1070 2. Undeveloped Real Estate 0300 Undeveloped Land Total ASSETS account
MA Codes • Organization of accounts for calculation of business analysis figures • Budgeting for account groups • 3 MA codes can be assigned per account • Any number of sub-totals • Assignments can be changed any time
GL Accounts • Account number, max. 20 characters, alphanumeric • Cost type • 3 FSCs, Debit/Credit for offsetting transactions • 3 MA codes • VAT tax lines • User-defined Additional Fields • 2 Budgeting Schemes
AR/AP Account Hierarchy • Fully new AR/AP account organization 230 A 001 Central Office All data 230 A 001/1 230 A 001/2 Branch/1 Branch 2 Branch /3 Separate address, Linked to ACC 1 Number of central Office for OI
AR/AP Accounts • Account number, max. 20 characters, alphanumeric • Sub-account option • Offsetting account (OI area) • Payment Terms • User-defined Additional Fields • Contact Partners • 2 Budgeting Schemes
Payment Terms • Any number of payment term lines • 2 description lines (e. g. , for printing in CWL ACC 2) • Two-phase discount terms • Net days definition
Foreign Currency Code • Any number of foreign currencies • Up to 3 rates per currency • Calculation: FC amount / Unit x Rate • Collections charges definable in FC • Automated posting of currency rate difference amounts
Data Entry • Posting Real Time Batch • Void Postings • Split Postings • Recurring Transactions • Automated Payment Transactions • Posting Payment Batch
Data Entry • Immediate Payment • Clearing (Electronic Payment Transfers) • Payment Reconciliation • Bank Account Reconciliation • GL Open Invoices • Posting Batch EXIM
Posting • 8 Posting methods: • • Posting Real Time Batch Purchase Invoices (PI) Sales Invoices (SI) Cash Accounts (PO) Batch (ACC 2) Posting (Batch) Void entries Split entries
Posting Types • Pre-defined: PO = GL posting SI = Customer invoice PI = Vendor invoice SP = Customer payment PP = Vendor payment OE = Opening entries(Period 0) CE = Closing entries (Period 13) beeinflussen OP
Cancel Postings (Void Entries) • Any posting can be voided quickly • Automatic adjustment in OI area • Automatic correction in the COST Journal
Trial Balances • Income statement scenarios based on alternative posting batch inclusion • Account sheets with “new balances“ • Complete balance sheet with inclusion of alternate posting batch scenarios • Adoption of the desired batch variant to the Yearly Journal
Recurring Transactions • Periodic processing of pre-defined posting batches • Event Plan: • • • How often From when / to when Last run of batch Grace Days Batch number that should be duplicated
Automated Payment Transactions • Payment suggestion lists • Printing of Debit Transfer forms • Printing of checks • Bank debit / credit transfer memo • Clearing Output • Refunding of credit notes • Discount optimizing • Automated OI reconciliation
Post Payment Batch • The payments confirmed by the bank statement are automatically set to “valid” and posted • If the previous payment run is not confirmed, the OIs marked as “reconciled” can be reset to original condition with the click of a mouse.
Immediate Payment • Creation of payments (e. g. , check print out), without having to create an OI (e. g. , payment to postman, vendors, etc. ) • Check print out, credit transfer form, clearing file • Automatic posting of payments
Bank Account Reconciliation (Balancing) • Reconciliation of already posted lines with a bank statement • Difference between Journal and bank statement are calculated on a running basis and displayed • Direct interface to posting dialogue (for adjusting postings)
Reports • Journals • Account Sheets • Account Balance sheets (also in FC) • Balance Sheets • Consolidated Balance Sheets • MA code lists • Budget lists
Reports • Cash Book • Open Invoice reports • Past Due Reminders • FSC Account Sheets • Budget reports • VAT • Summary reporting (Intrastat)
Reports • Difference lists • FC History list • ACC 1 -COST checking • GL Account Open Invoices • File Copy Output
Yearly Closing Procedures • Create New Company • New company number • Adoption of ACC 1 Base Info (accounts, FSCs, etc. ) • No automatic adoption of Product Base Info • No automatic adoption of Open Invoices
Yearly Closing Procedures • Yearly Closing • Automatic adoption of ALL Base Info (accts. , products, etc. ) • Automatic adoption of Open Invoices at the time point of the closing
Yearly Closing Procedures • OE Posting Adoption (automatic): • The OE balances can be reconciled as often as needed ( “OE difference” checkbox) • Any OE posting account desired • Any OE posting date desired • OE posting areas can be selected freely by account type and number area
Yearly Closing Procedures • OE posting adoption (manual): • Open postings for GL accounts (no recalculation of tax and posting in OE period) (separated evaluation) • Mandatory opening of AR/AP accounts with SI/PI, so that OI area can be populated (dummy previous year company) • Observe the tax base figures for invoices (for discount calculation and VAT correction)
Yearly Closing Procedures • OI adoption (retroactive): • Function allows you to reconcile retroactively (after yearly closing) open invoices from a previous year company • OIs can be reconciled as often as needed • Only OI lines (invoices or payments) that did not exist yet at the yearly closing are reconciled.
Data Check • Should be regularly performed • Checking of various areas: • Base Info • Transaction data
Reorg (Data record deletion) • Deletion of no longer needed data records • Open Invoices Dates, invoice numbers • Vouchers Date, voucher numbers • Base Info when set to inactive and not used (posting)
- Slides: 38