{"product_id":"agi-avstamning-arbetsgivardeklaration-lon-word-pdf-excel","title":"AGI Reconciliation \u0026 Employer Declaration – Salary, Control \u0026 Excel | Word\/PDF","description":"\u003csection lang=\"sv\" class=\"mb-product-content\" style=\"line-height:1.65;color:#173B55\"\u003e\n\u003cp\u003e\u003cstrong\u003eAGI Reconciliation \u0026amp; Employer Declaration – Salary and Control\u003c\/strong\u003e is a digital template package that helps Swedish companies, payroll administrators, and associations document checks of employer declarations at the individual level (AGI). Compare payroll journals, AGI drafts, and accounting entries, investigate differences, and distinguish internal certification from the Swedish Tax Agency's actual submission receipt.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eImportant limitation:\u003c\/strong\u003e The templates are a manual administrative aid, not an official employer declaration, payroll software, or tax calculator. The package does not determine tax rates, tax deductions, individual fields, social security, or correction methods, nor does it submit data to the Swedish Tax Agency.\u003c\/p\u003e\n\n\u003cdiv style=\"border:2px solid #137F85;border-radius:12px;padding:18px;background:#EAF6F5;margin:18px 0\"\u003e\n\n\u003ch2 style=\"margin:0 0 8px;color:#173B55\"\u003e01. Package Contents\u003c\/h2\u003e\n\n\u003cp style=\"margin:0\"\u003e\u003cstrong\u003e15 files in ZIP:\u003c\/strong\u003e 7 editable Word documents (DOCX), 7 corresponding searchable PDF versions for printing, and 1 Excel workbook (XLSX) with nine tabs. Five operational Swedish templates, one Swedish user guide, and a separate English User Guide. The working templates are available only in Swedish.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003cdiv style=\"border:2px solid #244965;border-radius:12px;padding:18px;background:#F1F5FA;margin:18px 0\"\u003e\n\n\u003ch2 style=\"margin:0 0 8px;color:#173B55\"\u003e02. What the Files Contain\u003c\/h2\u003e\n\n\u003cp style=\"margin:0\"\u003eAGI reconciliation protocol, manual employer basis, difference and correction investigation, payroll\/period checklist, and certification with submission receipt. Excel compiles reporting periods, report comparisons, accounting reconciliation, control points, deviations, and manual statuses. No personal identity numbers or individual salary details need to be entered in the overall log.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003ch2\u003eDocuments in the Template Package\u003c\/h2\u003e\n\n\u003cdiv style=\"overflow-x:auto\"\u003e\u003ctable style=\"width:100%;border-collapse:collapse\"\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth style=\"text-align:left;border-bottom:1px solid #BDD0D7;padding:8px\"\u003eFile\u003c\/th\u003e\n\n\u003cth style=\"text-align:left;border-bottom:1px solid #BDD0D7;padding:8px\"\u003eFunction\u003c\/th\u003e\n\n\u003cth style=\"text-align:left;border-bottom:1px solid #BDD0D7;padding:8px\"\u003eFormat\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e01. AGI Reconciliation Protocol\u003c\/td\u003e\n\n\u003ctd\u003ePeriod, total amount, source report, differences, and control responsibility\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e02. Manual Employer Basis\u003c\/td\u003e\n\n\u003ctd\u003eEmployer totals and reference to control in an authorized payroll system\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e03. Difference \u0026amp; Correction Investigation\u003c\/td\u003e\n\n\u003ctd\u003eCause, original period, proposal, special correction conditions, and actual receipt\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e04. Payroll \u0026amp; Period Control\u003c\/td\u003e\n\n\u003ctd\u003ePayment month, salary types, benefits, deviations, and manual control questions\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e05. AGI Approval \u0026amp; Receipt\u003c\/td\u003e\n\n\u003ctd\u003eCertification before submission and separate documentation of the authority's receipt\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e06. Swedish User Guide\u003c\/td\u003e\n\n\u003ctd\u003eStep-by-step, rules, and secure information handling\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e07. English User Guide\u003c\/td\u003e\n\n\u003ctd\u003eEnglish guidance for the Swedish working templates; not translated forms\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e08. Excel – AGI Control Register\u003c\/td\u003e\n\n\u003ctd\u003eNine tabs: periods, totals, accounting, controls, deviations, certification, and overview\u003c\/td\u003e\n\n\u003ctd\u003eExcel \/ XLSX\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\u003c\/div\u003e\n\n\u003ch2\u003eExcel: Nine Tabs with Formulas\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eStart, Periods, AGI_Sums, Accounting, Controls, Deviations, Certification, Overview, and Las_mig.\u003c\/strong\u003e Excel calculates \u003cem\u003earithmetic differences between two manually entered numbers\u003c\/em\u003e, including zero values. If comparison values are missing or are not numeric, the difference is left blank. The overview compiles manually specified periods, deviations, and statuses. There are no macros or direct links to the Swedish Tax Agency.\u003c\/p\u003e\n\n\u003cp\u003eThe workbook contains no payslips or individual data. To comply with data protection and confidentiality, the user should not enter personal identity numbers, personal salaries, or passwords in the shared control file. Control of individual data takes place in the organization's authorization-controlled payroll system.\u003c\/p\u003e\n\n\u003ch2\u003eHow to Use the AGI Templates\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDetermine the correct payment month\u003c\/strong\u003e and retrieve the current payroll journal and any AGI draft.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCompare the employer's totals\u003c\/strong\u003e for compensation, tax deductions, and employer contributions against reports and accounting.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eReview individual data securely\u003c\/strong\u003e in an authorization-controlled system; use only internal case references in overall logs.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eInvestigate deviations\u003c\/strong\u003e before submission, taking into account special rules for benefits, compensation types, fees, and corrections.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCertify internally\u003c\/strong\u003e and save the Swedish Tax Agency's actual submission receipt separately after the authorized person has submitted the declaration.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2\u003eLegal Starting Points and Important Exceptions\u003c\/h2\u003e\n\n\u003cp\u003e\u003ca href=\"https:\/\/www.skatteverket.se\/foretag\/arbetsgivare\/lamnaarbetsgivardeklaration.4.41f1c61d16193087d7fcaeb.html\"\u003eSwedish Tax Agency – Submit an Employer Declaration\u003c\/a\u003e describes the monthly reporting and what information may need to be submitted at the employer and individual levels. Employers must check the correct reporting period, authorization, and due date for their circumstances. The packages therefore do not use a generally prefilled submission date.\u003c\/p\u003e\n\n\u003cp\u003e\u003ca href=\"https:\/\/www.skatteverket.se\/foretag\/arbetsgivare\/lamnaarbetsgivardeklaration\/rattaenarbetsgivardeklaration.4.2cf1b5cd163796a5c8b6698.html\"\u003eSwedish Tax Agency – Correct an Employer Declaration\u003c\/a\u003e explains that incorrect AGI is normally corrected by submitting a new corrected declaration for the original period. For already deducted tax, there are special limitations: tax deductions normally cannot be reduced in a regular correction. When correcting individual data, it is important to retain the same specification number.\u003c\/p\u003e\n\n\u003cp\u003eFor the fields and definitions themselves, see \u003ca href=\"https:\/\/www.skatteverket.se\/agbeskrivning\"\u003eSwedish Tax Agency – How to Fill in the Employer Declaration\u003c\/a\u003e. Any personal data is handled separately in accordance with the General Data Protection Regulation and \u003ca href=\"https:\/\/www.imy.se\/verksamhet\/dataskydd\/\"\u003eIMY's data protection guidance\u003c\/a\u003e. No external lawyer, tax expert, or auditor has reviewed the package.\u003c\/p\u003e\n\n\u003ch2\u003eRelated Document Templates\u003c\/h2\u003e\n\n\u003cp\u003eFor the VAT flow of the reporting: \u003ca href=\"\/en\/products\/momsavstamning-momsdeklarationsunderlag-word-pdf-excel\"\u003eVAT Reconciliation \u0026amp; VAT Declaration Basis\u003c\/a\u003e. For planning personnel costs: \u003ca href=\"\/en\/products\/lonebudget-personalkostnadskalkyl-2026-2027-arbetsgivaravgifter-pension-budget-utfall-excel-word-pdf\"\u003ePayroll Budget \u0026amp; Personnel Cost Calculation\u003c\/a\u003e. For external payroll\/financial management: \u003ca href=\"\/en\/products\/uppdragsavtal-for-ekonomitjanster-mall-word-pdf\"\u003eAssignment Agreement for Financial Services\u003c\/a\u003e. For year-end reconciliations: \u003ca href=\"\/en\/products\/bokslutschecklista-avstamningsregister-2026-2027-balanskonton-bokslutsbilagor-arshjul-excel-word-pdf\"\u003eYear-End Checklist \u0026amp; Reconciliation Register\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\n\n\u003ch3\u003eCan I submit AGI with the Excel file?\u003c\/h3\u003e\n\n\u003cp\u003eNo. Excel is an internal control register. The employer declaration must be submitted via the Swedish Tax Agency's available submission methods.\u003c\/p\u003e\n\n\u003ch3\u003eDoes Excel calculate the correct employer contributions?\u003c\/h3\u003e\n\n\u003cp\u003eNo. Registered totals can be compared arithmetically, but applicable contribution rates and special rules must be determined in the actual payroll environment and based on the Swedish Tax Agency's guidance.\u003c\/p\u003e\n\n\u003ch3\u003eWhich month should AGI cover?\u003c\/h3\u003e\n\n\u003cp\u003eNormally, compensation is reported based on the payment month. Check current rules and special cases; do not confuse the payment month with the accrual month.\u003c\/p\u003e\n\n\u003ch3\u003eCan deducted tax be reduced through an AGI correction?\u003c\/h3\u003e\n\n\u003cp\u003eNormally not in the same way as, for example, employer contributions. Consult the Swedish Tax Agency's correction instructions for the individual case.\u003c\/p\u003e\n\n\u003ch3\u003eDoes individual-level payroll processing apply?\u003c\/h3\u003e\n\n\u003cp\u003eNo. Individual data must be checked in an authorization-controlled system and not copied into the general Excel register.\u003c\/p\u003e\n\n\u003ch3\u003eAre the working documents available in English?\u003c\/h3\u003e\n\n\u003cp\u003eNo. Five working documents are in Swedish. A separate English User Guide provides user instructions for the Swedish material.\u003c\/p\u003e\n\n\u003ch3\u003eAre the templates externally reviewed or approved by the authorities?\u003c\/h3\u003e\n\n\u003cp\u003eNo. Only internal AI-assisted source and file control has been performed. No external authority approval or expert opinion is claimed.\u003c\/p\u003e\n\n\u003cp\u003e\u003csmall\u003eVersion 1.0 · 24 October 2026 · Swedish Document Templates \/ Mallbutiken.se · Digital ZIP delivery after purchase.\u003c\/small\u003e\u003c\/p\u003e\n\n\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Standard","offer_id":56009658171734,"sku":"AGI-AVSTAMNING-V1","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/agi-avstamning-huvudbild-1600.webp?v=1792817441","url":"https:\/\/mallbutiken.se\/en\/products\/agi-avstamning-arbetsgivardeklaration-lon-word-pdf-excel","provider":"Mallbutiken","version":"1.0","type":"link"}