380 likes | 474 Vues
WINLine Financial Accounting Basis Seminar. Agenda. WINLine ACC1 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
E N D
Agenda • WINLine ACC1 • 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 ACC1 • 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 1010 I. INTANGIBLE ASSETS 1020 1. Concessions, Trademarks, etc. 0120 Software 1050 II. Physical Assets 1060 1. Developed Real Estate 0200 Developed Land 0210 Buildings 1070 2. Undeveloped Real Estate 0300 Undeveloped Land Total ASSETS Level 1 Level 3 Level 2 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, alpha-numeric • Cost type • 3 FSCs, Debit/Credit for offsetting transactions • 3 MA codes • VAT tax lines • User-defined Additional Fields • 2 Budgeting Schemes
230A001 230A001/1 230A001/2 230A001/2 AR/AP Account Hierarchy • Fully new AR/AP account organization Branch/1 Branch 2 Central Office All data Branch /3 Separate address, Linked to ACC1 Number of central Office for OI
AR/AP Accounts • Account number, max. 20 characters, alpha-numeric • 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 ACC2) • 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 (ACC2) • 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 • ACC1-COST checking • GL Account Open Invoices • File Copy Output
Yearly Closing Procedures • Create New Company • New company number • Adoption of ACC1 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 • VouchersDate, voucher numbers • Base Infowhen set to inactive and not used (posting)