Spreadsheet: 220746d1363257684-index-and-match-testgarysinvoicingsheet13v2
Sheet: Invoices-March

INVOICING 2013 - MARCH
 | INVOICE DATE: | 2013-03-31 00:00:00 | <- Enter the date that you want to appear on the invoices here! |  |  |  |  |  |  | ADDRESSES
 | INVOICE NUMBERS: |  |  |  |  |  |  |  |  | School1 |  | School5
 | 1 | 00461 - 03/2013 |  |  |  |  |  |  |  | xxx |  | xxx
 | 2 | 00462 - 03/2013 |  |  |  |  |  |  |  | xxx |  | xxx
 | 3 | 00463 - 03/2013 |  |  |  |  |  |  |  | xxx |  | xxx
 | 4 | 00464 - 03/2013
 | 5 | 00465 - 03/2013 |  |  |  |  |  |  |  | School2 |  | [NAME]
 | 6 1 | 00466 - 03/2013 |  |  |  |  |  |  |  | xxx |  | xxx
 | 7 2 | 00467 - 03/2013 |  |  |  |  |  |  |  | xxx |  | xxx
 | 8 3 | 00468 - 03/2013 |  |  |  |  |  |  |  | xxx |  | xxx
 |  |  |  |  |  |  |  |  |  |  |  | xxx
 |  |  |  |  |  |  |  |  |  | School3 |  | School6
 |  |  |  |  |  |  |  |  |  | xxx |  | xxx
 |  | CROSS CHECK |  |  |  |  |  |  |  | xxx |  | xxxx
 |  | TOTAL VALUE FROM INVOICES |  | TOTAL FROM SUMMARY |  |  | WEEK 09 | 27 Feb - 05 Mar |  | xxx |  | xxx
 |  | 1666 | 0 |  | 1450 |  | WEEK 10 | 06 Mar - 12 Mar
 |  | TOTAL CLASS HOURS (INV) |  | TOTAL FROM SUMMARY |  |  | WEEK 11 | 13 Mar - 19 Mar |  | School4 |  | NEW CUSTOMER 3
 |  | 44 | 0 |  | 46 |  | WEEK 12 | 20 Mar - 26 Mar |  | xxx |  | Address Line 1
 |  | TOTAL TRAVEL HOURS (INV) |  | TOTAL FROM SUMMARY |  |  | WEEK 13 | 27 Mar - 02 Mar |  | xxx |  | xxxxx Essen
 |  | 0 | 1 |  | 0 |  |  |  |  | xxx
RECHNUNG |  |  |  |  |  |  |  | RECHNUNG |  |  |  |  |  |  |  | RECHNUNG |  |  |  |  |  |  |  | RECHNUNG
 | Datum: | 2013-03-31 00:00:00 |  |  |  |  |  |  | Datum: | 2013-03-31 00:00:00 |  |  |  |  |  |  | Datum: | 2013-03-31 00:00:00 |  |  |  |  |  |  | Datum: | 2013-03-31 00:00:00
 |  |  |  | An |  |  |  |  |  |  |  | An |  |  |  |  |  |  |  | An |  |  |  |  |  |  |  | An
 | [NAME] |  |  | School1 |  |  |  |  | [NAME] |  |  | School2 |  |  |  |  | [NAME] |  |  | School3 |  |  |  |  | [NAME] |  |  | School4
 | xxx |  |  | xxx |  |  |  |  | xxx |  |  | xxx |  |  |  |  | xxx |  |  | xxx |  |  |  |  | xxx |  |  | xxx
 | 45139 Essen |  |  | xxx |  |  |  |  | 45139 Essen |  |  | xxx |  |  |  |  | 45139 Essen |  |  | xxx |  |  |  |  | 45139 Essen |  |  | xxx
 |  |  |  | xxx |  |  |  |  |  |  |  | xxx |  |  |  |  |  |  |  | xxx |  |  |  |  |  |  |  | xxx
 | Steuernummer: |  |  |  |  |  |  |  | Steuernummer: |  |  |  |  |  |  |  | Steuernummer: |  |  |  |  |  |  |  | Steuernummer:
 | RG-Nr: | 00461 - 03/2013 |  |  |  |  |  |  | RG-Nr: | 00462 - 03/2013 |  |  |  |  |  |  | RG-Nr: | 00463 - 03/2013 |  |  |  |  |  |  | RG-Nr: | 00464 - 03/2013
 |  |  | This data should come from the Summary
 | Date Here | The class here | The amount of lessons that day
 | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt |  |  | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt |  |  | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt |  |  | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt
 | 2013-03-12 00:00:00 | IT-E-EN-G-531 | 2 | 0 | 2 | 50 |  |  | 2013-02-27 00:00:00 | ISTA 14 | 14 | 0 | 14 | 770 |  |  | März - W9-13 | RWE 1 | 8 | 0 | 8 | 160 |  |  | März - W9-13 | [NAME] | 8 | 0 | 8 | 160
 | 2013-03-13 00:00:00 | IT-E-EN-E-556 | 2 | 0 | 2 | 50 |  |  |  |  |  |  |  | 0 |  |  | März - W9-13 | RWE 2 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | [NAME] und Verwaltungsklasse | 0 | 0 | 0 | 0
 | 2013-03-14 00:00:00 | IT-E-EN-E-556 | 2 | 0 | 2 | 50 |  |  |  |  |  |  |  | 0 |  |  | März - W9-13 | Englisch Conversation | 8 | 0 | 8 | 160 |  |  | März - W9-13 | Einzelunterricht Mitarbeiter [NAME] | 0 | 0 | 0 | 0
 | 2013-03-15 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  | März - W9-13 | Student 1 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Class X | 0 | 0 | 0 | 0
 | 2013-03-16 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  | März - W9-13 | Student 2 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Class Y | 0 | 0 | 0 | 0
 | 2013-03-17 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  | März - W9-13 | 2013-02-27 00:00:00 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 |  |  |  | Total | 14 | 0 | 14 | 770 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  | Total | 6 | 0 | 6 | 150 |  |  |  |  |  |  |  |  |  |  |  | Total | 16 | 0 | 16 | 320 |  |  |  | Total | 8 | 0 |  | 160
 | Honorar |  | 25 |  |  |  |  |  | Honorar |  | 55 |  |  |  |  |  | Honorar |  | 20 |  |  |  |  |  | Honorar |  | 20
 | Gesamt Unterrichtsstunden: |  | 6 | Stunden |  |  |  |  | Gesamt Unterrichtsstunden: |  | 14 | Stunden |  |  |  |  | Gesamt Unterrichtsstunden: |  | 16 | Stunden |  |  |  |  | Gesamt Unterrichtsstunden: |  | 8 | Stunden
 | Sonstiges: |  | 0 | Stunden |  |  |  |  | Sonstiges: |  | 0 | Stunden |  |  |  |  | Sonstiges: |  | 0 | Stunden |  |  |  |  | Sonstiges: |  | 0 | Stunden
 | Gesamt Netto: |  | 150 |  |  |  |  |  | Gesamt Netto: |  | 770 |  |  |  |  |  | Gesamt Netto: |  | 320 | € |  |  |  |  | Gesamt Netto: |  | 160 | €
 | Mwst. Betrag: 19% |  | 28.5 |  |  |  |  |  | Mwst. Betrag: 19% |  | 146.3 |  |  |  |  |  | Mwst. Betrag: 19% |  | 60.8 | € |  |  |  |  | Sonstiges: |  | 30.4 | €
 | Rechnungsbetrag: |  | 178.5 |  |  |  |  |  | Rechnungsbetrag: |  | 916.3 |  |  |  |  |  | Rechnungsbetrag: |  | 380.8 | € |  |  |  |  | Rechnungsbetrag: |  | 190.4 | €
RECHNUNG |  |  |  |  |  |  |  | RECHNUNG |  |  |  |  |  |  |  | RECHNUNG |  |  |  |  |  |  |  | RECHNUNG
 | Datum: | 2013-03-31 00:00:00 |  |  |  |  |  |  | Datum: | 2013-03-31 00:00:00 |  |  |  |  |  |  | Datum: | 2013-03-31 00:00:00 |  |  |  |  |  |  | Datum: | 41364
 |  |  |  | An |  |  |  |  |  |  |  | An |  |  |  |  |  |  |  | An |  |  |  |  | Ort: | Essen |  | An
 | [NAME] |  |  | School5 |  |  |  |  | [NAME] |  |  | [NAME] |  |  |  |  | [NAME] |  |  | School6 |  |  |  |  | [NAME] |  |  | NEW CUSTOMER 3
 | xxx |  |  | xxx |  |  |  |  | xxx |  |  | xxx |  |  |  |  | xxx |  |  | xxx |  |  |  |  | xxx |  |  | Address Line 1
 | 45139 Essen |  |  | xxx |  |  |  |  | 45139 Essen |  |  | xxx |  |  |  |  | 45139 Essen |  |  | xxxx |  |  |  |  | 45139 Essen |  |  | xxxxx Essen
 |  |  |  | xxx |  |  |  |  |  |  |  | xxx |  |  |  |  |  |  |  | xxx |  |  |  |  |  |  |  | 0
 | Steuernummer: |  |  |  |  |  |  |  | Steuernummer: |  |  | xxx |  |  |  |  | Steuernummer: |  |  |  |  |  |  |  | Steuernummer:
 | RG-Nr: | 00465 - 03/2013 |  |  |  |  |  |  | RG-Nr: | 00466 - 03/2013 |  |  |  |  |  |  | RG-Nr: | 00467 - 03/2013 |  |  |  |  |  |  | RG-Nr:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00468 - 03/2013
 | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt |  |  | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt |  |  | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt |  |  | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt
 | März - W9-13 | [NAME] | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Frau Fischer / Class 1 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Class 1 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Class 1 | 0 | 0 | 0 | 0
 | März - W9-13 | 0 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | New Customer 1 / Class 2 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Class 2 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Class 2 | 0 | 0 | 0 | 0
 | März - W9-13 | 0 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | New Customer 1 / Class 3 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Class 3 | 0 | 0 | 0 | 0 |  |  | März - W9-13 | Class 3 | 0 | 0 | 0 | 0
 | März - W9-13 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  | März - W9-13 | Class 4 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  | März - W9-13 | Class 5 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  | Total | 0 | 0 | 0 | 0 |  |  |  | Total | 0 | 0 | 0 | 0 |  |  |  | Total | 0 | 0 | 0 | 0 |  |  |  | Total | 0 | 0 | 0 | 0
 | Honorar |  | 35 |  |  |  |  |  | Honorar |  | 30 |  |  |  |  |  | Honorar |  | 120 |  |  |  |  |  | Honorar |  | 0
 | Gesamt Unterrichtsstunden: |  | 0 | Stunden |  |  |  |  | Gesamt Unterrichtsstunden: |  | 0 | Stunden |  |  |  |  | Gesamt Unterrichtsstunden: |  | 0 | Stunden |  |  |  |  | Gesamt Unterrichtsstunden: |  | 0 | Stunden
 | Sonstiges: |  | 0 | Stunden |  |  |  |  | Sonstiges: |  | 0 | Stunden |  |  |  |  | Sonstiges: |  | 0 | Stunden |  |  |  |  | Sonstiges: |  | 0 | Stunden
 | Gesamt Netto: |  | 0 | € |  |  |  |  | Gesamt Netto: |  | 0 | € |  |  |  |  | Gesamt Netto: |  | 0 | € |  |  |  |  | Gesamt Netto: |  | 0 | €
 | Mwst. Betrag: 19% |  | 0 | € |  |  |  |  | Mwst. Betrag: 19% |  | 0 | € |  |  |  |  | Mwst. Betrag: 19% |  | 0 | € |  |  |  |  | Mwst. Betrag: 19% |  | 0 | €
 | Rechnungsbetrag: |  | 0 | € |  |  |  |  | Rechnungsbetrag: |  | 0 | € |  |  |  |  | Rechnungsbetrag: |  | 0 | € |  |  |  |  | Rechnungsbetrag: |  | 0 | €
RECHNUNG
 | Datum: | 41364
 | Ort: | Essen |  | An
 | [NAME] |  |  | School5
 | xxxx |  |  | xxx
 | 45139 Essen |  |  | xxx
 |  |  |  | xxx
 | Steuernummer:
 | RechnungNr:
 | 00465 - 03/2013
 | Datum | Firma/Kurs! Teilnehmer-in | Anzahl Unterrichts-stunden | Sonstiges | TOTAL | Gesamt
 | März - W9-13 | 0 | 0 | 0 | 0 | 0
 | März - W9-13 | 0 | 0 | 0 | 0 | 0
 | März - W9-13 | 0 | 0 | 0 | 0 | 0
 | März - W9-13 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  | Total | 0 | 0 | 0 | 0
 | [NAME] |  | 35
 | Gesamt Unterrichtsstunden: |  | 0 | Stunden
 | Faktor: |  | 0 | Stunden
 | Gesamt Netto: |  | 0 | €
 | Sonstiges: |  | 0 | €
 | Rechnungsbetrag: |  | 0 | €