start stop invoice pay acc amount whom why filename start stop invoice pay start stop invoice pay
 
This page introduces the chronology prefix of invoice folders. The prefix is constructed from 4 ordered date elements. The 1st element represents the billing period's start date, the 2nd is the billing period's end date, the third is the invoice date, and the forth is the payment date. The code "+E" marks an unavailable i.e. empty element. All empty elements of leading positions are truncated. The chronology prefix starts only from the first available non-empty date element. All following positions must be shown, even if they are empty. Therefore the last element (empty or not) represents always the payment date. The first available date element is provided in YYMMDD format. Following elements are shown as increments in days (either positive, or negative).

Fields of filenames are separated by comma signs. The first field of the file is the chronology field, as described above. The second field is the 2-letter code of the account in charge of the invoice ("sw", "in", "pr", or "yo"). The third field represents the amount in CHF. It is positive if the account is charged (i.e. in case of an invoice) and is negative in case of a payment. The forth element is the balance of the invoice in question (i.e. the remaining amount to pay). The fifth and sixth fields are the beneficiary and the subject respectively. Such filename formats are applicable for naming invoices, payment orders, and folders representing current open balance and containing the initial invoices followed by payment orders.
 
Converts dates to prefx (web page) [go]  
Converts dates to prefx (excel file) [xls]  
Converts prefix to dates (web page) [go]  
Converts prefix to dates (excel file) [xls]  
This web page's mirror #1 [go]  
This web page's mirror #2 [go]