PCCaddie

Menu

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 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:

You can now make the desired settings:

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.

(3) specifies an output directory where the CVS files should be exported.

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).

PC CADDIE asks again if the fiscal export for the selected account range should be started.

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 PC CADDIE user, and the output directory.

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.

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.

The export files will look like this:

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 PC CADDIE, and confirm with OK.

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
<Empty> = 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 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
en/umsaetze/gobd/gobd.txt · Last modified: 2021/01/08 17:30 by emilia
  • No tags, yet
Was this page helpful?-1-2+1