Model Factura Excel v2 [PDF]

Zitiervorschau

FACTURA Seria ZZZ Numarul 0016 Data (AAAA-LL-ZZ) 2014-12-20 Cota TVA 19% FURNIZOR SC FIRMA MEA SRL Reg. Com.: CIF: Adresa:

CLIENT Bebe clientus primulus tuicus Reg. Com.: CIF: Adresa:

IBAN: Banca:

0

Nr. crt.

0 Denumirea poduselor sau a serviciilor U.M. Cantitatea 0 1 Prestari servicii cf. contract. …

Intocmit de: CNP: BI/CI: Numele delegatului: Mijloc de transport: Semnatura, stampila furnizorului

SC FIRMA MEA SRL

1

2 buc

Pretul unitar Valoarea (fara TVA) - (Lei) (Lei) 3 4 1 3000

Valoarea TVA - (Lei) 5(3x4) 3000

6 570

Termen de plata:

2015-02-01

3000

570

Total (Lei) Total de plata (Lei)

3570

Semnatura de primire

Model factura luat de pe excelninja.ro

Seria Furnizor Reg. com. CIF Cont Banca: Adresa:

BIZ Nr. 0015 SC Learnvest SRL-D J5/816/2013 RO 31645554 RO16 INGB 0000 9999 0386 1320 ING Str. Gheorghe Doja, Nr. 49A, Oradea, Jud. Bihor

Am primit de la SC CLIENT 6 Adresa Adresa … Suma de 500 lei adica cinci sute lei reprezentand contravaloarea facturii seria BIZ

Seria Furnizor Reg. com. CIF Cont Banca: Adresa:

CHITANTA Seria BIZ Nr. Data (zi, luna, an) CIF RO XXXXXXXX

Nr 0015

BIZ Nr. 0015 SC Learnvest SRL-D J5/816/2013 RO 31645554 RO16 INGB 0000 9999 0386 1320 ING Str. Gheorghe Doja, Nr. 49A, Oradea, Jud. Bihor

Am primit de la SC CLIENT 6 Adresa Adresa … Suma de 500 lei adica cinci sute lei reprezentand contravaloarea facturii seria BIZ

Reg. com.

0015 12/20/2014 J05/XXX/XXXX

din data 12/20/2014

CHITANTA Seria BIZ Nr. Data (zi, luna, an) CIF RO XXXXXXXX

Nr 0015

Reg. com.

din data 12/20/2014

0015 12/20/2014 J05/XXX/XXXX

0001

Data Descriere emiterii 1 0001-1 2014/07/01 Prestari servicii cf. contract. …

SC CLIENT 1

Cota TVA 24%

0002

1 0002-1

2014/07/15 Prestari servicii cf. contract. …

SC CLIENT 2

24%

0003

1 0003-1

2014/07/29 Prestari servicii cf. contract. …

SC CLIENT 3

24%

0004

1 0004-1

2014/08/12 Prestari servicii cf. contract. …

SC CLIENT 4

24%

0005

1 0005-1

2014/08/26 Prestari servicii cf. contract. …

SC CLIENT 5

24%

0006

1 0006-1

2014/09/09 Prestari servicii cf. contract. …

SC CLIENT 6

24%

0007

1 0007-1

2014/09/23 Prestari servicii cf. contract. …

SC CLIENT 7

24%

0008

1 0008-1

2014/10/07 Prestari servicii cf. contract. …

SC CLIENT 8

24%

0009

1 0009-1

2014/10/21 Prestari servicii cf. contract. …

SC CLIENT 9

24%

0010

1 0010-1

2014/11/04 Prestari servicii cf. contract. …

SC CLIENT 10

24%

0011

1 0011-1

2014/11/18 Prestari servicii cf. contract. …

SC CLIENT 11

24%

0012

1 0012-1

2014/12/02 Prestari servicii cf. contract. …

SC CLIENT 12

24%

0013

1 0013-1

2014/12/16 Prestari servicii cf. contract. …

SC CLIENT 6

24%

0014

2 0014-2

2014/12/18 Prestari servicii cf. contract. …

SC CLIENT 6

24%

0015

3 0015-3

2014/12/20 Prestari servicii cf. contract. …

SC CLIENT 6

24%

0016

1 0016-1

2014/12/20 Prestari servicii cf. contract. …

Bebe clientus primulus tuicus

19%

Nr.

Nr CRT

ID

Emisa catre

buc

6

140.00 lei

840.00 lei

Termen de Data Status plata incasarii 201.60 lei 2014-07-15 2014-07-15 Achitat

buc

1

440.00 lei

440.00 lei

105.60 lei

2014-07-28

2014-07-28 Achitat

buc

1

685.00 lei

685.00 lei

164.40 lei

2014-08-10

2014-08-10 Achitat

buc

3

607.00 lei

1,821.00 lei

437.04 lei

2014-08-23

2014-08-23 Achitat

buc

1

2,000.00 lei

2,000.00 lei

480.00 lei

2014-09-05

2014-09-05 Achitat

buc

1

450.00 lei

450.00 lei

108.00 lei

2014-09-18

2014-09-18 Achitat

buc

1

1,580.00 lei

1,580.00 lei

379.20 lei

2014-10-01

2014-10-01 Achitat

buc

1

2,200.00 lei

2,200.00 lei

528.00 lei

2014-10-14

2014-10-14 Achitat

buc

1

375.00 lei

375.00 lei

90.00 lei

2014-10-27

2014-10-27 Achitat

buc

5

5,000.00 lei

25,000.00 lei

6,000.00 lei

2014-11-09

2014-11-09 Achitat

buc

1

6,000.00 lei

6,000.00 lei

1,440.00 lei

2014-11-22

Neachitat

buc

1

875.00 lei

875.00 lei

210.00 lei

2014-12-05

Neachitat

buc

1

600.00 lei

600.00 lei

144.00 lei

2014-12-18

Neachitat

buc

7

888.00 lei

6,216.00 lei

1,491.84 lei

2015-01-01

Neachitat

buc

2

10,000.00 lei

20,000.00 lei

4,800.00 lei

2015-02-01

Neachitat

buc

1

3,000.00 lei

3,000.00 lei

570.00 lei

2015-02-01

Neachitat

UM

Cantitatea

Pret unitar

Valoare

TVA

Nume firma SC CLIENT 1 SC CLIENT 2 SC CLIENT 3 SC CLIENT 4 SC CLIENT 5 SC CLIENT 6 SC CLIENT 7 SC CLIENT 8 SC CLIENT 9 SC CLIENT 10 SC CLIENT 11 SC CLIENT 12 Bebe clientus primulus tuicus

CUI RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX RO XXXXXXXX

Nr ORC J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX J05/XXX/XXXX

Adresa Adresa … Adresa … Adresa … Adresa … Adresa … Adresa … Adresa … Adresa … Adresa … Adresa … Adresa … Adresa …

IBAN XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX

Banca Banca … Banca … Banca … Banca … Banca … Banca … Banca … Banca … Banca … Banca … Banca … Banca …

Status

Achitat

40000 35391

35000

Data incasarii Sum - Valoare Jul ### 30000 Aug ### Sep ### 25000 Oct ### 20000 Nov ### Total Result ###

25000

15000 10000 5000 1280 0 Jul

2506

2450

Aug

Sep

4155

Oct

Nov

Tota l Res ul t

35391

Sum - Va l oare

Tota l Res ul t

Status

- multiple -

Data emiterii Sum - Valoare Jul 1,965.00 lei Aug 3,821.00 lei Sep 2,030.00 lei Oct 2,575.00 lei Nov 31,000.00 lei Dec 30,691.00 lei Total Result 72,082.00 lei

80000 70000 60000 50000 40000 30000 20000 10000 0 Jul

Aug

Sep

Oct

Nov

Dec

Tota l

Nov

Dec

Tota l Res ul t

Emisa catre Sum - Valoare SC CLIENT 6 ### SC CLIENT 10 ### SC CLIENT 11 ### Bebe clientus p ### SC CLIENT 8 ### SC CLIENT 5 ### SC CLIENT 4 ### SC CLIENT 7 ### SC CLIENT 12 ### SC CLIENT 1 ### SC CLIENT 3 ### SC CLIENT 2 ### SC CLIENT 9 ### (empty) Total Result ###

4.16%

2.53%

2.19% 1.21% 2.77% 3.05%

8.32%

34.68%

1.17%

0.95%

0.61%

0.52% 37.83%

SC CLIENT 6 SC CLIENT 10 SC CLIENT 11 Bebe cl i entus pri mul us tui cu SC CLIENT 8 SC CLIENT 5 SC CLIENT 4 SC CLIENT 7 SC CLIENT 12 SC CLIENT 1 SC CLIENT 3 SC CLIENT 2 SC CLIENT 9 (empty)

SC CLIENT 6 SC CLIENT 10 SC CLIENT 11 Bebe cl i entus pri mul us tui cus SC CLIENT 8 SC CLIENT 5 SC CLIENT 4 SC CLIENT 7 SC CLIENT 12 SC CLIENT 1 SC CLIENT 3 SC CLIENT 2 SC CLIENT 9 (empty)

Folosind Excel in mod inteligent economisesti timpul tau, cel mai pretios lucru din lume!

Daca doresti să participi la un curs exel nivel intermediar avansat viziteaza www.traininguri.ro/agendă-cursuri si vezi cand este

Scurt Tutorial video: cum sa folosesti corect acest model factura excel: https://www.traininguri.ro/model-factura-excel/ Mai multe detalii despre Radu Popa poti afla aici: https://www.traininguri.ro/radu-popa/

Linkuri utile cursuri excel: Curs Excel Timisoara: https://www.traininguri.ro/curs-excel-timisoara/ Curs Excel Bucuresti: https://www.traininguri.ro/curs-excel/

Curs Excel Cluj: https://www.traininguri.ro/curs-excel-cluj/

Cursuri Excel pentru companii: https://www.traininguri.ro/cursuri-excel-in-companii/

Agenda cursuri Extreme Training: https://www.traininguri.ro/agenda-cursuri/