====== Data export auditing ====== :!: GoBD: Principles for the proper management, storage and access of books and records in electronic form The menu entry **Accounts/Fiscal-Export** opens the data export auditing. The files issued here are stored in CVS format and can be read in by the tax office. Please pay attention to which account area you are in. If you want to output the data from a cash account area, such as SALES, please change to the relevant account area before exporting to GoBD. You can find out how to change the account area under [[http://doku.pccaddie.com/doku.php?id=en:umsaetze:kontenbereichwaehlen:kontenbereichwaehlen|Select account area]] If you need export data from an archived area, please change to the respective archive area beforehand. Clicking on **Fiscal-Export** opens the following window: {{:en:umsaetze:gobd:datenexport.png?500|}} You can now make the desired settings: {{:en:umsaetze:gobd:datenexport nummeriert.png?500|}} The period to be exported is defined at (1). You have the possibility to choose between two invoice PDF exports at (2). * **Invoices sent by email**: only the invoices sent by e-mail are exported. or * **All invoices**: all invoices written in the period defined above are exported as a PDF file. {{:en:umsaetze:gobd:datenexport rechnungen.png?500|}} (3) specifies an output directory where the CVS files should be exported. {{:en:umsaetze:gobd:datenexport nummeriert.png?500|}} If you want to password protect the files, enter a corresponding password at (4). This will be required later when opening the export files. Click on **Export** (5). Pcc asks again if the fiscal export for the selected account range should be started. {{:en:umsaetze:gobd:datenexport starten.png|}} Confirm with **Export**. You will receive some relevant information after the export is done: the account area output, the time period, the date and time of the export, the name of the computer, the Windows user, the Pcc user, and the output directory. {{:en:umsaetze:gobd:datenexport zusammenfassung.png?500|}} confirm with **OK**. Then the file explorer (Windows Explorer) opens with the selected link (1) and a ZIP folder (2). The exported account area and time range are included in the name of the ZIP folder. You can open the ZIP folder with a double-click. {{:en:umsaetze:gobd:gobd_explorer.png|}} This ZIP folder contains another subfolder with the name of the account area. You can also open this folder with a double-click. Inside are the CVS files that you can open with your standard spreadsheet program. {{:en:umsaetze:gobd:gobd_umsatz_neu.png|}} The export files will look like this: {{:en:umsaetze:gobd:gobd_dateien.png?600|}} If you have assigned a password and want to open one of the above mentioned files, you get the following message. Here you must then enter the password previously entered in Pcc, and confirm with **OK**. {{:en:umsaetze:gobd:gobd_pw.png|}} ===== Export files===== The following list shows the contents of each file: ==== ARTICLE.CSV ==== Used articles in the defined period of the exported account range ^ Field name^ Description^ | CODE | Unique ID | | NAME | Name | | WAGR | Articles group ID | | NETTO | Net price | | BRUTTO | Gross price| | MWST | Tax rate in percent| | FIBU | FA number | ==== ARTICLE_GROUP.CSV ==== Used articles groups in the defined period of the exported account range ^ Field name^ Description^ | CODE | Unique ID | | NAME | Name | | AREACODE | Booking area ID | | AREANAME | Booking area Name | | FIBU | FA number | ==== BOOKINGS.CSV ==== All entries from the selected account area are listed. :!: The fields important for economic evaluations are marked in bold. ^ Field name ^ Description^ | **KONTMITGCO** | Customer number from CUSTOMER.CSV, MITGCODE | | **KONTBEITCO** | Internal article number from GOLFBEIT.DBF, BEITCODE | | KONTBEITSU | First four characters of the "external" article number | | **KONTBEITNA** | Booking text; Price: ..... = price changes| | KONTEKNET | Purchase price of the booked article (rarely used) (Net) | | KONTVKORG | Original selling price in case of discounts (gross) | | **KONTBRUTTO** | Gross price including VAT for the line item| | **KONTNETTO** | Net price without VAT for the line item| | **KONTMWST** | Tax rate in % | | KONTZAHLT | Paid amount - used only in special cases| | KONTWAEHR | Currency for foreign currency payments | | **KONTDATUM** | Booking date| | **KONTZEIT** | Booking time| | **KONTSTATUS** | Status of the entry | | | 0 = Notes without own booking value (invoice header etc.)| | | 3 = Normal bookings | | | 4 = Booking with variable price (Article "Divers" etc.)| | | 5 = Booking with free text | | | 7 = Card bookings (Charges on prepaid cards)| | **KONTTYP** | Booking type| | | = Normal | | | R = Invoice header| | | Z = Payment| | | D = Deleted | | | p = Price changes | | | A = Adjustment of article number| | | U = Rebooking| | | K = Cash register| | | W = Articles movement booking (if an item is distributed to several, this posting may not be included in the balance)| | | v = Corresponding follow-up bookings| | **KONTBEZ** | Status | | | 0 = Not recorded| | | 1 = In invoice | | | 2 = Retracted| | | 4 = Partly payed | | | 5 = Payed | | KONTMAHND | Reminder date| | KONTMAHN | Reminder level| | **KONTRGNR** | Invoice / receipt number| | **KONTRGDAT** | Invoice date | | KONTBEZDAT | Payment date| | KONTFIBU | Update status in Financial Accounting (at accounting interface) | | KONTAREA | Cash register area (in case of large facilities with several cash register areas) | | KONTSTAREA | Statistics area (for evaluations according to customer types, seldom used) | | KONTXINFO | Extended information for special cases | | KONTSTORNO | //Not used// | | KONTRABATT | Discount rate in % | | KONTNUTZER | Encrypted user ID | | KONTCHKSUM | Line checksum, usually not used| | KONTINDX01 | Internal link | | KONTINDX02 | Internal link | | KONTINDX03 | Internal link | ==== CASH_PROTOCOL.CSV ==== All cash book entries are outputed. Similar to the cash register [[http://doku.pccaddie.com/doku.php?id=en:umsaetze:kassenprotokoll:kassenprotokoll|protocol]] ==== CASHBOOK.CSV ==== Cashbook bookings ==== CHANGE_PROTOCOL.CSV ==== All changes are logged in this file. * Article changes * User changes (New, Change, Delete) * Confirm cash balance * Disable GoDB-compliant cash book * Day-end closing * Cancel several bills * Cancel the invoice * Invoice number changes ==== CUSTOMER.CSV ==== Used customers in the defined period of the exported account range ^ Field number^ Description ^ | CODE | User ID | | SUCH | Search abbreviations| ==== INFO.TXT ==== Information about the fiscal export * Issued account area * Period of bookings / invoices * Date and time of export * Computer name * Windows user * PC CADDIE user * Path to the PC CADDIE main directory