10.10 Invoice > Cash book

10.10 Invoice - Cash book

All postings, bank postings (account statements), direct debits, SEPA transfers and SEPA mandates are managed in the Invoice - Cashbook program section. Postings in the posting list are entered automatically when invoices and credit notes are posted. Bank postings (account statements) can be transferred from various online banking programs to gFM-Business.

10.10.1 Invoice > Cash book > Postings: Fields

  • Booking no. - Sequential number of the booking record
  • Date - Date of booking
  • Booking text - Booking text of the booking
  • Debit account - Debit account of the posting
  • Credit account - Credit account of the posting
  • Cost center - Cost center to which the posting was assigned
  • Gross amount - Gross amount
  • DATEV amount indicator - is required for DATEV export, automatic entry
  • DATEV tax key - is required for DATEV export, automatic entry

Invoice: Cash book

10.10.2 Invoice > Cash book > Postings: Functions

  • Bank import - This function can be used to transfer bank bookings (account statements) from various online banking programs to gFM Business. Postings from Bank X and MacGiro can be imported directly via the clipboard and as a file. Files from StarMoney and standardized MT940 files from other online banking programs can also be imported. After selecting this function, a dialog box opens in which the desired import path and the target account for which the bookings are to be imported are selected. All accounts are displayed as the target account that have been selected in the settings under Specifications > Invoice have been defined as a financial account. If the import is carried out via the clipboard, the desired bookings must first be copied to the clipboard in the online banking program. After clicking on the button [Import] the postings are imported into gFM-Business and assigned to the selected account.
  • Booking export - gFM-Business supports the data export of postings in the formats DATEV (EXTF/CSV or DATEV export package), MonkeyOffice and as an individual export. After selecting this function, a dialog box appears in which you can select the desired file format and specify which postings are to be exported. You can also specify whether the postings should receive a corresponding status after export. Click on the button [Export] the postings are exported to a file in the desired format. If "DATEV export package" is selected, both the DATEV export file (EXTF/CSV) and all associated documents are saved in PDF format and automatically packed as a zip archive.
  • New credit note (national transfer) - This function can be used to generate a new credit note as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the recipient account, the sort code, account number, reason for payment and the amount can be specified. This function will be replaced by the SEPA credit transfer from February 2014.
  • New direct debit (national transfer) - This function can be used to create a new direct debit as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the third-party account, the sort code, account number, reason for payment and the amount can be specified. Direct debits can also be created directly in the customer data record of the [Customers] module for the corresponding customer. This function will be replaced by the SEPA credit transfer from August 2014.
  • New SEPA transfer - This function can be used to create a new SEPA direct debit or SEPA credit transfer. From February 2014, SEPA direct debits will replace conventional direct debits. A valid SEPA mandate signed by the customer is required to execute a SEPA direct debit. After selecting this function, a dialog box appears in which all the details for the new SEPA transfer can be entered. The fields Own account, Transfer type, Account holder of the third-party account, BIC, IBAN, Purpose, EzE reference (unique reference of a SEPA transfer) and the amount to be debited are available. After clicking on the button [New] a new SEPA transfer is created and entered in the register button [SEPA transfers] changed. In the last step, assign the created SEPA transfer to a customer. SEPA transfers can also be created directly in the customer data record of the [Customers] for the corresponding customer (recommended method).
  • New SEPA mandate - Use this function to create SEPA mandates in order to be able to create SEPA direct debits or SEPA credit transfers in the future. A SEPA mandate requires the following information, which must be entered in the dialog box: One-off or recurring payment, unique reference and name, address, postcode/city, country, SWIFT BIC and IBAN of the third-party account holder. SEPA mandates can be entered directly in the customer data record of the [Customers] (recommended method).

10.10.3 Invoice > Cash book > Postings: Context-sensitive functions

  • New booking - Use this function to create a new posting record in the cashbook. By clicking on the [+] button on the right-hand side of the window, you can select the account to which you want to post an expense or income before the posting dialog. The following details for a posting record must be entered in the posting dialog: Posting date, posting text, gross amount, VAT rate, debit account, credit account and optionally a cost center. Click on the button [New] the new posting record is entered in the cashbook. Click on the posting in the posting list at the bottom of the screen to display all the details of the posting.
  • Duplicate booking - This function can be used to duplicate the selected posting after a dialog query and create an identical posting data record in the cashbook.
  • Posting - This function can be used to post the selected booking after a dialog query so that it is no longer included as an unposted booking in the data export or can be changed retrospectively. This process can be carried out with the Cancel be canceled.
  • Cancel - Cancels the booking status of the selected booking if the booking has already been marked as booked.
  • Booking export - gFM-Business supports the data export of postings in the formats DATEV (EXTF/CSV), MonkeyOffice and as an individual export. After selecting this function, a dialog box appears in which you can select the desired file format and specify which postings are to be exported. You can also specify whether the postings should receive a corresponding status after export. Click on the button [Export] the bookings are exported to a file in the desired format.

10.10.4 Invoice > Cash book > Bank entries: Fields

Invoice: Bank postings

  • Booking no. - Sequential number of the booking record
  • Extract no. - Sequence number of the account statement
  • Date - Date of booking
  • Transmitter/receiver - Sender and recipient of the booking
  • Intended use - Purpose of the booking
  • Output (target) - Debit account (output) of the posting
  • Revenue (credit) - Credit account (revenue) of the posting

10.10.5 Invoice > Cash book > Bank entries: Functions

  • Bank import - This function can be used to transfer bank bookings (account statements) from various online banking programs to gFM Business. Postings from Bank X and MacGiro can be imported directly via the clipboard and as a file. Files from StarMoney and standardized MT940 files from other online banking programs can also be imported. After selecting this function, a dialog box opens in which the desired import path and the target account for which the bookings are to be imported are selected. all accounts that are selected in the settings under Specifications > Invoice have been defined as a financial account. If the import is carried out via the clipboard, the desired postings must first be copied to the clipboard in the online banking program. After clicking on the button [Import] the postings are imported into gFM-Business and assigned to the selected account.
  • Booking export - gFM-Business supports the data export of postings in the formats DATEV (EXTF/CSV), MonkeyOffice and as an individual export. After selecting this function, a dialog box appears in which you can select the desired file format and specify which postings are to be exported. You can also specify whether the postings should receive a corresponding status after export. Click on the button [Export] the bookings are exported to a file in the desired format.
  • New credit note (national transfer) - This function can be used to generate a new credit note as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the recipient account, the sort code, account number, reason for payment and the amount can be specified. This function will be replaced by the SEPA credit transfer from February 2014.
  • New direct debit (national transfer) - This function can be used to create a new direct debit as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the third-party account, the sort code, account number, reason for payment and the amount can be specified. Direct debits can also be created directly in the customer data record of the [Customers] module for the corresponding customer. This function will be replaced by the SEPA credit transfer from February 2014.
  • New SEPA transfer - This function can be used to create a new SEPA direct debit or SEPA credit transfer. From February 2014, SEPA direct debits will replace conventional direct debits. A valid SEPA mandate signed by the customer is required to execute a SEPA direct debit. After selecting this function, a dialog box appears in which all the details for the new SEPA transfer can be entered. The fields Own account, Transfer type, Account holder of the third-party account, BIC, IBAN, Purpose, EzE reference (unique reference of a SEPA transfer) and the amount to be debited are available. After clicking on the button [New] a new SEPA transfer is created and entered in the register button [SEPA transfers] changed. In the last step, assign the created SEPA transfer to a customer. SEPA transfers can also be created directly in the customer data record of the [Customers] for the corresponding customer (recommended method).
  • New SEPA mandate - Use this function to create SEPA mandates in order to be able to create SEPA direct debits or SEPA credit transfers in the future. A SEPA mandate requires the following information, which must be entered in the dialog box: One-off or recurring payment, unique reference and name, address, postcode/city, country, SWIFT BIC and IBAN of the third-party account holder. SEPA mandates can be entered directly in the customer data record of the [Customers] (recommended method).

10.10.6 Invoice > Cash book > Bank entries: Context-sensitive functions

  • Bank import - This function can be used to transfer bank bookings (account statements) from various online banking programs to gFM Business. Postings from Bank X and MacGiro can be imported directly via the clipboard and as a file. Files from StarMoney and standardized MT940 files from other online banking programs can also be imported. After selecting this function, a dialog box opens in which the desired import path and the target account for which the bookings are to be imported are selected. All accounts are displayed as the target account that are selected in the settings under Specifications > Invoice have been defined as a financial account. If the import is carried out via the clipboard, the desired postings must first be copied to the clipboard in the online banking program. After clicking on the button [Import] the postings are imported into gFM-Business and assigned to the selected account.
  • Assign invoice - You can use this function to manually assign the bank posting called up to an invoice. Selecting this function opens a dialog box in which a selection menu of all open invoices is displayed. By clicking on the button [Assign]the selected invoice is assigned to the selected bank posting and marked as paid. This function is used if the automatic assignment of a payment could not be carried out successfully, e.g. due to an incorrectly written purpose. If the [Post] radio button is activated, the payment is automatically posted to the cashbook.
  • Delete booking - Use this function to delete the selected booking from the database. A corresponding query dialog appears before the deletion process. Attention: A deleted bank booking is irrevocably removed and cannot be restored.
  • Delete selected bookings - This function can be used to delete all bookings from the database that have been selected in the left-hand selection area. The selection field is located below the status field for the export status.
  • Delete all bookings - This function can be used to delete all bank bookings in the database. Attention: Deleted bank bookings are irrevocably removed and cannot be restored.

10.10.7 Invoice > Cashbook > Direct debits: Fields

Invoice: Direct debits

  • Customer no. - Customer number to which the direct debit was assigned
  • Date - Date of the direct debit
  • Third-party account: Holder - Name of the third-party account holder
  • External account: SORT CODE - Bank code of the third-party account holder
  • External account no. - Account number of the third-party account
  • Own account: SORT CODE - Bank code of the personal account
  • Own account no. - Account number of the personal account
  • Intended use - Purpose of the direct debit
  • Transfer type - Transfer type of direct debit (direct debit or credit)
  • Subspecies - Single version or collective version
  • Output form - HBCI, paper, DTA or BTX
  • Amount - Amount of the direct debit
  • Executed on - Date of export to an online banking program

10.10.8 Invoice > Cash book > Direct debits: Functions

  • Bank import - This function can be used to transfer bank bookings (account statements) from various online banking programs to gFM Business. Postings from Bank X and MacGiro can be imported directly via the clipboard and as a file. Files from StarMoney and standardized MT940 files from other online banking programs can also be imported. After selecting this function, a dialog box opens in which the desired import path and the target account for which the bookings are to be imported are selected. all accounts that are selected in the settings under Specifications > Invoice have been defined as a financial account. If the import is carried out via the clipboard, the desired postings must first be copied to the clipboard in the online banking program. After clicking on the button [Import] the postings are imported into gFM-Business and assigned to the selected account.
  • Booking export - gFM-Business supports the data export of postings in the formats DATEV (EXTF/CSV), MonkeyOffice and as an individual export. After selecting this function, a dialog box appears in which you can select the desired file format and specify which postings are to be exported. You can also specify whether the postings should receive a corresponding status after export. Click on the button [Export] the bookings are exported to a file in the desired format.
  • New credit note (national transfer) - This function can be used to generate a new credit note as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the recipient account, the sort code, account number, reason for payment and the amount can be specified. This function will be replaced by the SEPA credit transfer from August 2014.
  • New direct debit (national transfer) - This function can be used to create a new direct debit as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the third-party account, the sort code, account number, reason for payment and the amount can be specified. Direct debits can also be created directly in the customer data record of the [Customers] module for the corresponding customer. This function will be replaced by the SEPA credit transfer from February 2014.
  • New SEPA transfer - This function can be used to create a new SEPA direct debit or SEPA credit transfer. From February 2014, SEPA direct debits will replace conventional direct debits. A valid SEPA mandate signed by the customer is required to execute a SEPA direct debit. After selecting this function, a dialog box appears in which all the details for the new SEPA transfer can be entered. The fields Own account, Transfer type, Account holder of the third-party account, BIC, IBAN, Purpose, EzE reference (unique reference of a SEPA transfer) and the amount to be debited are available. After clicking on the button [New] a new SEPA transfer is created and entered in the register button [SEPA transfers] changed. In the last step, assign the created SEPA transfer to a customer. SEPA transfers can also be created directly in the customer data record of the [Customers] for the corresponding customer (recommended method).
  • New SEPA mandate - Use this function to create SEPA mandates in order to be able to create SEPA direct debits or SEPA credit transfers in the future. A SEPA mandate requires the following information, which must be entered in the dialog box: One-off or recurring payment, unique reference and name, address, postcode/city, country, SWIFT BIC and IBAN of the third-party account holder. SEPA mandates can be entered directly in the customer data record of the [Customers] (recommended method).

10.10.9 Invoice > Cashbook > Direct debits: Context-sensitive functions

  • New direct debit (national transfer) - This function can be used to create a new direct debit as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the third-party account, the sort code, account number, reason for payment and the amount can be specified. Direct debits can also be created directly in the customer data record of the [Customers] be created for the corresponding customer. This function will be replaced by the SEPA credit transfer from August 2014.
  • Export direct debits - This function can only be called up once one or more direct debits have been selected in the list. Only selected direct debits can be exported. After calling up this function, a dialog box opens in which the desired export format can be selected. You can choose between Bank X direct, MacGiro direct, MacGiro as file, DTAUS file and individual export in text or Excel format. For direct exports, the corresponding online banking program must be open.
  • Delete direct debit - This function can be used to delete the selected direct debit from the database after a query dialog. The direct debit is irrevocably deleted and cannot be restored.
  • Delete selected direct debits - Deletes all direct debits that are selected at the time the function is called after a query dialog. The direct debits are irrevocably deleted and cannot be restored.
  • Delete all direct debits - Deletes all direct debits in the database after a query dialog. The direct debits are irrevocably deleted and cannot be restored.

10.10.10 Invoicing > Cashbook > SEPA transfers: Fields

Invoice: SEPA transfers

  • Customer no. - Customer number to which the direct debit was assigned
  • Date- Date of the direct debit
  • Third-party account: Holder - Name of the third-party account holder
  • External account: SORT CODE - Bank code of the third-party account holder
  • External account no. - Account number of the third-party account
  • Own account: SORT CODE - Bank code of the personal account
  • Own account no. - Account number of the personal account
  • Intended use - Purpose of the direct debit
  • Transfer type - Transfer type of direct debit (direct debit or credit)
  • Subspecies - Single version or collective version
  • Output form - HBCI, paper, DTA or BTX
  • Amount - Amount of the direct debit
  • Executed on - Date of export to an online banking program

10.10.11 Invoice > Cashbook > SEPA transfers: Functions

  • Bank import - This function can be used to transfer bank bookings (account statements) from various online banking programs to gFM Business. Postings from Bank X and MacGiro can be imported directly via the clipboard and as a file. Files from StarMoney and standardized MT940 files from other online banking programs can also be imported. After selecting this function, a dialog box opens in which the desired import path and the target account for which the bookings are to be imported are selected. all accounts that are selected in the settings under Specifications > Invoice have been defined as a financial account. If the import is carried out via the clipboard, the desired postings must first be copied to the clipboard in the online banking program. After clicking on the button [Import] the postings are imported into gFM-Business and assigned to the selected account.
  • Booking export - gFM-Business supports the data export of postings in the formats DATEV (EXTF/CSV), MonkeyOffice and as an individual export. After selecting this function, a dialog box appears in which you can select the desired file format and specify which postings are to be exported. You can also specify whether the postings should receive a corresponding status after export. Click on the button [Export] the bookings are exported to a file in the desired format.
  • New credit note (national transfer) - This function can be used to generate a new credit note as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the recipient account, the sort code, account number, reason for payment and the amount can be specified. This function will be replaced by the SEPA credit transfer from August 2014.
  • New direct debit (national transfer) - This function can be used to create a new direct debit as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the third-party account, the sort code, account number, reason for payment and the amount can be specified. Direct debits can also be created directly in the customer data record of the [Customers] module for the corresponding customer. This function will be replaced by the SEPA credit transfer from February 2014.
  • New SEPA transfer - This function can be used to create a new SEPA direct debit or SEPA credit transfer. From February 2014, SEPA direct debits will replace conventional direct debits. A valid SEPA mandate signed by the customer is required to execute a SEPA direct debit. After selecting this function, a dialog box appears in which all the details for the new SEPA transfer can be entered. The fields Own account, Transfer type, Account holder of the third-party account, BIC, IBAN, Purpose, EzE reference (unique reference of a SEPA transfer) and the amount to be debited are available. After clicking on the button [New] a new SEPA transfer is created and entered in the register button [SEPA transfers] changed. In the last step, assign the created SEPA transfer to a customer. SEPA transfers can also be created directly in the customer data record of the [Customers] for the corresponding customer (recommended method).
  • New SEPA mandate - Use this function to create SEPA mandates in order to be able to create SEPA direct debits or SEPA credit transfers in the future. A SEPA mandate requires the following information, which must be entered in the dialog box: One-off or recurring payment, unique reference and name, address, postcode/city, country, SWIFT BIC and IBAN of the third-party account holder. SEPA mandates can be entered directly in the customer data record of the [Customers] (recommended method).

10.10.12 Invoice > Cashbook > SEPA transfers: Context-sensitive functions

  • New SEPA transfer - This function can be used to create a new SEPA direct debit or SEPA credit transfer. From August 2014, SEPA direct debits will replace conventional direct debits. A valid SEPA mandate signed by the customer is required to execute a SEPA direct debit. After selecting this function, a dialog box appears in which all the details for the new SEPA transfer can be entered. The fields Own account, Transfer type, Account holder of the third-party account, BIC, IBAN, Purpose, EzE reference (unique reference of a SEPA transfer) and the amount to be debited are available. After clicking on the button [New] a new SEPA transfer is created and entered in the register button [SEPA transfers] changed. In the last step, assign the created SEPA transfer to a customer. SEPA transfers can also be created directly in the customer data record of the [Customers]for the corresponding customer (recommended method).
  • Export SEPA transfers - This function can only be called up once one or more SEPA transfers have been selected in the list. Only selected SEPA transfers can be exported. After calling up this function, a dialog box opens in which the desired export format can be selected. You can choose between Bank X direct, MacGiro direct, MacGiro as file, SEPA XML file and individual export in text or Excel format. For direct exports, the corresponding online banking program must be open.
  • Delete SEPA transfer - This function can be used to delete the selected direct debit from the database after a query dialog. The direct debit is irrevocably deleted and cannot be restored.
  • Delete marked SEPA transfers - Deletes all direct debits that are selected at the time the function is called after a query dialog. The direct debits are irrevocably deleted and cannot be restored.
  • Delete all SEPA transfers - Deletes all direct debits in the database after a query dialog. The direct debits are irrevocably deleted and cannot be restored.

10.10.13 Invoice > Cashbook > SEPA mandates: Fields

Billing: SEPA mandates

  • Mandate ID - Consecutive number (mandate ID)
  • Customer ID - Customer ID to which the SEPA mandate was assigned
  • Payer: Name - Name of the debtor
  • SWIFT BIC - BIC of the third-party account
  • IBAN - IBAN of the third-party account
  • Valid from, valid until - Period during which the SEPA mandate is valid
  • Mandate reference - Unique reference of the SEPA mandate
  • Method of payment - One-off or recurring payment
  • Agreement with - Name with which the agreement was made
  • Payer: Street, No. - Address of the debtor
  • Payer: Postcode, town - Zip code and city of the debtor
  • Payer: Country - Country of the debtor

10.10.14 Invoice > Cashbook > SEPA mandates: Functions

  • Bank import - This function can be used to transfer bank bookings (account statements) from various online banking programs to gFM Business. Postings from Bank X and MacGiro can be imported directly via the clipboard and as a file. Files from StarMoney and standardized MT940 files from other online banking programs can also be imported. After selecting this function, a dialog box opens in which the desired import path and the target account for which the bookings are to be imported are selected. All accounts are displayed as the target account that have been selected in the settings under Specifications > Invoice have been defined as a financial account. If the import is carried out via the clipboard, the desired postings must first be copied to the clipboard in the online banking program. After clicking on the button [Import] the postings are imported into gFM-Business and assigned to the selected account.
  • Booking export - gFM-Business supports the data export of postings in the formats DATEV (EXTF/CSV), MonkeyOffice and as an individual export. After selecting this function, a dialog box appears in which you can select the desired file format and specify which postings are to be exported. You can also specify whether the postings should receive a corresponding status after export. Click on the button [Export] the bookings are exported to a file in the desired format.
  • New credit note (national transfer) - This function can be used to generate a new credit note as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the recipient account, the sort code, account number, reason for payment and the amount can be specified. This function will be replaced by the SEPA credit transfer from August 2014.
  • New direct debit (national transfer) - This function can be used to create a new direct debit as a national transfer. In the following dialog box, after selecting this function, the own account and the transfer type can be selected and the account holder of the third-party account, the sort code, account number, reason for payment and the amount can be specified. Direct debits can also be created directly in the customer data record of the [Customers] module for the corresponding customer. This function will be replaced by the SEPA credit transfer from February 2014.
  • New SEPA transfer - This function can be used to create a new SEPA direct debit or SEPA credit transfer. From February 2014, SEPA direct debits will replace conventional direct debits. A valid SEPA mandate signed by the customer is required to execute a SEPA direct debit. After selecting this function, a dialog box appears in which all the details for the new SEPA transfer can be entered. The fields Own account, Transfer type, Account holder of the third-party account, BIC, IBAN, Purpose, EzE reference (unique reference of a SEPA transfer) and the amount to be debited are available. After clicking on the button [New] a new SEPA transfer is created and entered in the register button [SEPA transfers] changed. In the last step, assign the created SEPA transfer to a customer. SEPA transfers can also be created directly in the customer data record of the [Customers] for the corresponding customer (recommended method).
  • New SEPA mandate - Use this function to create SEPA mandates in order to be able to create SEPA direct debits or SEPA credit transfers in the future. A SEPA mandate requires the following information, which must be entered in the dialog box: One-off or recurring payment, unique reference and name, address, postcode/city, country, SWIFT BIC and IBAN of the third-party account holder. SEPA mandates can be entered directly in the customer data record of the [Customers] (recommended method).

10.10.15 Invoice > Cashbook > SEPA mandates: Context-sensitive functions

  • New SEPA mandate - Use this function to create SEPA mandates in order to be able to create SEPA direct debits or SEPA credit transfers in the future. A SEPA mandate requires the following information, which must be entered in the dialog box: One-off or recurring payment, unique reference and name, address, postcode/city, country, SWIFT BIC and IBAN of the third-party account holder. SEPA mandates can be entered directly in the customer data record of the [Customers] (recommended method).
  • Print SEPA mandate - You can use this function to print the selected SEPA direct debit mandate on a printer. After a query dialog, the system print dialog appears, in which the printer to be used can be selected and further settings can be made.
  • Duplicate SEPA mandate - This function can be used to duplicate the selected SEPA direct debit mandate and create a new data record with identical details. This function can be used, for example, to create another SEPA direct debit mandate for an existing customer.
  • Delete SEPA mandate - After a dialog query, this function can be used to delete the selected SEPA mandate from the database. The SEPA mandate is irrevocably deleted with this function and cannot be restored.