• Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Download the Excel template to consolidate tax declaration data

0 Comments

Tax declaration is a regular accounting task that must be done monthly, quarterly, and annually. In this article, Buffcom.net will share with readers an Excel template for consolidating tax declaration data to help accountants easily check tax declaration data.

Steps to check the declared tax data:

  • 1. Value-added tax

  • Check if the value-added tax declaration for the month (quarter) has been fully submitted;
  • Check if the data on the purchase and sale invoice list matches the value-added tax declaration for the month (quarter) and the balance of accounts 133, 3331 in the ledger;
  • Check if the additional, adjusted, increased or decreased declaration forms are prepared in accordance with regulations;
  • Check if the invoices are complete according to the invoice list; If any are missing, they need to be reviewed or reported as lost invoices to the tax authority;
  • Check the tax declaration for the contractor tax and incidental taxes;
  • Check the report on the use of invoices
  • Check if the report on the use of invoices for the month (quarter) has been fully submitted;
  • Check if the issued invoices have been notified;
  • Check if the report on the use of invoices for the month (quarter) matches the invoices used in the period; If any invoices have been cancelled, make sure the minutes of the invoice withdrawal are complete and if not, they need to be supplemented.

    2. Personal income tax

  • If there are deductions for personal income tax for newly employed workers during the declaration period, a personal income tax declaration form must be submitted.
  • Check if the number of employees with labor contracts, the taxable personal income tax amount, and the deducted personal income tax amount on the salary sheet match;
  • If there are payments for wages to new employees during the financial year, a personal income tax settlement declaration form must be submitted.
  • Check if the personal income tax settlement declaration form matches the salary sheet and ledger 334 details;
  • Check if employee information such as name, tax code, and dependent information are accurately declared;
  • Check if the deducted insurance amounts match the insurance records.

    3. Corporate income tax

  • Check if the annual income tax settlement declaration form has been submitted;
  • Based on the financial report prepared, check according to the corporate income tax law (Circular 96/2015/TT-BTC), for example, some criteria such as:
  • Deductible and non-deductible expenses when settling taxes;
  • Adjusted increased or decreased profits before tax;
  • Loss transfer rules;
  • Cases of tax incentives, reductions or exemptions.
Download the Excel template to consolidate tax declaration data

Download the Excel template to consolidate tax declaration data

9
57 Views
How to search for data by row and column in ExcelPrevHow to search for data by row and column in ExcelMarch 3, 2023
Guide readers on 3 ways to enter formulas in ExcelMarch 3, 2023Guide readers on 3 ways to enter formulas in ExcelNext

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $11.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.