How was the accounting before spreadsheets

Excel template for your accounting and EÜR

Accounting with Excel (spreadsheet program)

In accounting, smaller entrepreneurs like to work with Excel spreadsheets. Many have that too Advantages: the programs are cheap, reliable and easy to use. But whether this is also permissible is often disputed. The accounting should namely be "GoBD-compliant". But what does that mean?

The "Principles for the proper management and storage of books, records and documents in electronic form as well as for data access" (GoBD) are the basis for digital bookkeeping. For electronic records (bookings) this means that they must be kept unchanged and may not be deleted before the retention period has expired.

Records are unchangeable if it is possible to trace changes. However, Excel lists can easily be changed without the changes being indicated. The bookings in the form of Excel lists therefore do not guarantee the continuous, complete and correct recording of all business transactions.

Excel files can only meet immutability and traceability with additional measures. You should therefore also save your Excel table as a PDF / a file and keep it unchangeable. Changes to a PDF / a file are no longer possible. So you can meet the legal requirements with an Excel list. You can also record the data using our online accounting. (See tips and hints)

Important / note: A GoBD-compliant bookkeeping with only Excel files is not possible. In addition to the Excel tables, you must therefore save the accounting data as a PDF / a file (File / Print / PDF file).

But there could also be other reasons against Excel accounting, such as the value added tax. You not only have to keep records according to the Income Tax Act, but also the record-keeping obligations under the Sales Tax Act. You also need the Advance VAT return electronically (ELSTER) to the tax office.

In addition, income excess calculators must have a Annex EÜR submit. Assigning the accounts by hand is complex and time-consuming.

But this only applies if you are not a good (professional) Excel template for your accounting to have. With our Excel template, you can book professionally with the right one Accounts (Chart of accounts is deposited) and received professional evaluations for sales tax, determination of profits according to Section 4 (3) EStG with Annex EÜR and business evaluations with graphics.

Even if you don't want to do your accounting yourself, you can use the Excel table for pre-entry and yours tax consultant provide. If he takes advantage of the digital benefits of collaboration, he will cost cutting pass it on to you. You can therefore link our Excel template to Buchomat's online accounting and simply upload the data. (See tips and hints)


Download Excel template accounting + EÜR

You are looking for one Excel templatewith which your Bookkeeping and determination of profits with the EÜR system be able to submit it to the tax office quickly and easily via ELSTER?

Then you should now use our Excel template download and test.

It's simple: all you have to do is yours Income and expenditure Enter in the Excel template and the table will calculate your profit.

With the Excel template, you can easily create professional accounting by adding the Financial accounting account enter. You can find a chart of accounts in the table on the right. You can use our online bookkeeping to record the data (see tips and information).


With this tool you have your finances under control and can send your accounting data ready-made or for further processing to yours tax consultant (e.g. www.steuerschroeder.de) or to others Accounting programs (especially our online accounting).


The Excel spreadsheet creates a Income surplus calculation and the EÜR annex. You can also use your EÜR online to the tax office to transfer.



Buy Excel spreadsheet now: »Accounting-Excel.xlsx«


Hints:
You need for that pay no (own) PayPal account. You can pay quickly and securely with your account or credit card.

After we have received your payment, we will send you the table by email
(usually the same working day).

Thank you for your order and your trust. We wish you every success with our accounting table.

Your Cyberlab team

Additionally: »Kassenbuch.xlsm«
Additionally: »Kassenbericht.xlsm incl. Cash book«
Additionally: »Travel expense report-template-Excel-2016.xlsm«

Tips and hints for using the Excel template for your accounting:

The template was specially made for the online accounting developed. The data can easily be transferred from the Excel table to the online accounting. With online accounting, you can too VAT returns submit. Online accounting offers many other advantages, such as automatic accounting for known business transactions, etc. It is best to convince yourself of the many advantages of the online accountinghttps://ms-buchhalter.de/buchomat/.

Note: The accounting created with an Excel spreadsheet is not unalterable and thus in the sense of a double-entry bookkeeping (in contrast to the income surplus calculation) not properly (even the printout of the tables cannot change that). Therefore, the template for the income statement is fine. For financial accounting, the table is still a brilliant tool and help, because we have developed a simple solution for you to write down the data: online accounting (see below). You can read here whether you need to create double bookkeeping and a balance sheet ...

The bookkeeping data must therefore be required if the bookkeeping is required codified become. You can do this in different ways:

  1. You give your completed Excel spreadsheet with your accounting data to you on a regular basis tax consultant or
  2. They use our online accountinghttps://ms-buchhalter.de/buchomat/. Of course, you can also work with your tax advisor with the online version.

tip: The table with the Annex EÜR is automatically created from your bookings. In the worksheet is a tax law Help included so that you can account accordingly. You can then access the EÜR online via MAGPIE Send to the tax office.

Buy the Excel spreadsheet now & download it immediately: »Accounting-Excel.xlsx«


Hints:
You need for that pay no (own) PayPal account. You can pay quickly and securely with your account or credit card.

After we have received your payment, we will send you the table by email
(usually the same working day).

Thank you for your order and your trust. We wish you every success with our accounting table.

Your Cyberlab team

Additionally: »Kassenbuch.xlsm«
Additionally: »Kassenbericht.xlsm incl. Cash book«
Additionally: »Travel expense report-template-Excel-2016.xlsm«