ToolsDays to pay
Which of your clients take longest to pay?
Drop your Harvest invoice report and see how many days each client takes to pay you on average, against your other clients, and what each still owes, with every sum shown. A calculation from your file, not credit advice.
Sample invoices, January to September
A design agency's invoices, all made up for this demo
Check your own invoices
Your export stays in this browser
Slowest to pay, on average
65 days
From 1 January to 2 September 2026, Northline Freight took 65 days on average to pay its 6 invoices, against 23.6 days for your other clients, and it still owes you $17,850.00 on 3 open invoices.
65 days = 390 days ÷ 6 invoices, added up under Northline Freight below. 23.6 days = 1,772 days ÷ 75 invoices, your other clients’ invoices paid in full. 1,772 days = 2,162 days for all clients − 390 days for Northline Freight, and 75 invoices = 81 − 6. $17,850.00 = $3,450.00 + $7,950.00 + $6,450.00, Northline Freight’s 3 open invoices. Days to pay run from an invoice’s issue date to its last payment, on invoices paid in full.
Every client, slowest to pay first
| ClientInvoices in your file | Paid in full | Days to pay, on average | Still owes you |
|---|---|---|---|
| Northline Freight9 invoices | 6 | 65 days390 days ÷ 6 | $17,850.00$3,450.00 + $7,950.00 + $6,450.00 3 open invoices, the oldest issued 1 Jul |
| Juniper Credit Union9 invoices | 7 | 59.4 days416 days ÷ 7 | $38,400.00$19,200.00 + $19,200.00 2 open invoices, the oldest issued 3 Aug |
| Summit Physical Therapy9 invoices | 8 | 34 days272 days ÷ 8 | $3,900.001 open invoice, the oldest issued 1 Sep |
| Ridgeview Realty7 invoices | 7 | 32.6 days228 days ÷ 7 | Nothing |
| Harbor Point Dental9 invoices | 8 | 32.5 days260 days ÷ 8 | $4,500.001 open invoice, the oldest issued 1 Sep |
| Larkspur Hotel Group4 invoices | 4 | 31 days124 days ÷ 4 | Nothing |
| Ferro Tool & Die3 invoices | 3 | 29.3 days88 days ÷ 3 | Nothing |
| Copperline Fitness2 invoices | 1 | 28 days28 days ÷ 1 | Nothing |
| Tidewater Schools Foundation3 invoices | 2 | 26 days52 days ÷ 2 | $3,000.001 open invoice, the oldest issued 19 Aug |
| Alder & Finch Law9 invoices | 9 | 17.6 days158 days ÷ 9 | Nothing |
| Oakwell Brewing2 invoices | 2 | 16.5 days33 days ÷ 2 | Nothing |
| Willow Creek Senior Living6 invoices | 6 | 15.5 days93 days ÷ 6 | Nothing |
| Cascade Trail Outfitters9 invoices | 9 | 1.3 days12 days ÷ 9 | Nothing |
| Bramble Bakery9 invoices | 9 | 0.9 days8 days ÷ 9 | Nothing |
| All 14 clients | 81 | 26.7 days2,162 days ÷ 81 14 clients added up | $67,650.00$17,850.00 + $38,400.00 + $3,900.00 + $4,500.00 + $3,000.00 |
Each client’s invoices
Northline Freight, 9 invoices, 65 days on average, owes you $17,850.00
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1042Row 3 | 1 Jan 2026 | 2 Mar 2026 | 60 days1 Jan to 2 Mar | $7,050.00 | $7,050.00 | $0.00 | Paid in full |
| 1051Row 12 | 2 Feb 2026 | 10 Apr 2026 | 67 days2 Feb to 10 Apr | $7,650.00 | $7,650.00 | $0.00 | Paid in full |
| 1061Row 22 | 2 Mar 2026 | 18 May 2026 | 77 days2 Mar to 18 May | $7,950.00 | $7,950.00 | $0.00 | Paid in full |
| 1072Row 33 | 1 Apr 2026 | 10 Jun 2026 | 70 days1 Apr to 10 Jun | $7,800.00 | $7,800.00 | $0.00 | Paid in full |
| 1083Row 44 | 1 May 2026 | 29 Jun 2026 | 59 days1 May to 29 Jun | $6,750.00 | $6,750.00 | $0.00 | Paid in full |
| 1094Row 55 | 1 Jun 2026 | 28 Jul 2026 | 57 days1 Jun to 28 Jul | $8,250.00 | $8,250.00 | $0.00 | Paid in full |
| 1104Row 65 | 1 Jul 2026 | 21 Sep 2026 | $6,450.00 | $3,000.00 | $3,450.00 | Part paid, open | |
| 1114Row 75 | 3 Aug 2026 | None | $7,950.00 | $0.00 | $7,950.00 | Open | |
| 1123Row 84 | 1 Sep 2026 | None | $6,450.00 | $0.00 | $6,450.00 | Open | |
| Paid in full, 6 invoices | 390 days6 invoices added up | 65 days on average390 days ÷ 6 | |||||
| Open, 3 invoices | $17,850.00$3,450.00 + $7,950.00 + $6,450.00 |
Juniper Credit Union, 9 invoices, 59.4 days on average, owes you $38,400.00
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1041Row 2 | 1 Jan 2026 | 16 Mar 2026 | 74 days1 Jan to 16 Mar | $19,650.00 | $19,650.00 | $0.00 | Paid in full |
| 1050Row 11 | 2 Feb 2026 | 6 Apr 2026 | 63 days2 Feb to 6 Apr | $21,900.00 | $21,900.00 | $0.00 | Paid in full |
| 1060Row 21 | 2 Mar 2026 | 4 May 2026 | 63 days2 Mar to 4 May | $25,500.00 | $25,500.00 | $0.00 | Paid in full |
| 1071Row 32 | 1 Apr 2026 | 27 May 2026 | 56 days1 Apr to 27 May | $24,150.00 | $24,150.00 | $0.00 | Paid in full |
| 1082Row 43 | 1 May 2026 | 22 Jun 2026 | 52 days1 May to 22 Jun | $19,350.00 | $19,350.00 | $0.00 | Paid in full |
| 1093Row 54 | 1 Jun 2026 | 15 Jul 2026 | 44 days1 Jun to 15 Jul | $24,900.00 | $24,900.00 | $0.00 | Paid in full |
| 1103Row 64 | 1 Jul 2026 | 3 Sep 2026 | 64 days1 Jul to 3 Sep | $20,850.00 | $20,850.00 | $0.00 | Paid in full |
| 1113Row 74 | 3 Aug 2026 | None | $19,200.00 | $0.00 | $19,200.00 | Open | |
| 1122Row 83 | 1 Sep 2026 | None | $19,200.00 | $0.00 | $19,200.00 | Open | |
| Paid in full, 7 invoices | 416 days7 invoices added up | 59.4 days on average416 days ÷ 7 | |||||
| Open, 2 invoices | $38,400.00$19,200.00 + $19,200.00 |
Summit Physical Therapy, 9 invoices, 34 days on average, owes you $3,900.00
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1044Row 5 | 1 Jan 2026 | 5 Feb 2026 | 35 days1 Jan to 5 Feb | $4,050.00 | $4,050.00 | $0.00 | Paid in full |
| 1053Row 14 | 2 Feb 2026 | 9 Mar 2026 | 35 days2 Feb to 9 Mar | $4,650.00 | $4,650.00 | $0.00 | Paid in full |
| 1063Row 24 | 2 Mar 2026 | 7 Apr 2026 | 36 days2 Mar to 7 Apr | $4,650.00 | $4,650.00 | $0.00 | Paid in full |
| 1074Row 35 | 1 Apr 2026 | 1 May 2026 | 30 days1 Apr to 1 May | $4,050.00 | $4,050.00 | $0.00 | Paid in full |
| 1085Row 46 | 1 May 2026 | 2 Jun 2026 | 32 days1 May to 2 Jun | $4,050.00 | $4,050.00 | $0.00 | Paid in full |
| 1096Row 57 | 1 Jun 2026 | 10 Jul 2026 | 39 days1 Jun to 10 Jul | $4,500.00 | $4,500.00 | $0.00 | Paid in full |
| 1106Row 67 | 1 Jul 2026 | 7 Aug 2026 | 37 days1 Jul to 7 Aug | $3,600.00 | $3,600.00 | $0.00 | Paid in full |
| 1116Row 77 | 3 Aug 2026 | 31 Aug 2026 | 28 days3 Aug to 31 Aug | $4,200.00 | $4,200.00 | $0.00 | Paid in full |
| 1125Row 86 | 1 Sep 2026 | None | $3,900.00 | $0.00 | $3,900.00 | Open | |
| Paid in full, 8 invoices | 272 days8 invoices added up | 34 days on average272 days ÷ 8 | |||||
| Open, 1 invoice | $3,900.00 |
Ridgeview Realty, 7 invoices, 32.6 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1064Row 25 | 2 Mar 2026 | 1 Apr 2026 | 30 days2 Mar to 1 Apr | $4,950.00 | $4,950.00 | $0.00 | Paid in full |
| 1075Row 36 | 1 Apr 2026 | 4 May 2026 | 33 days1 Apr to 4 May | $5,850.00 | $5,850.00 | $0.00 | Paid in full |
| 1086Row 47 | 1 May 2026 | 10 Jun 2026 | 40 days1 May to 10 Jun | $5,400.00 | $5,400.00 | $0.00 | Paid in full |
| 1097Row 58 | 1 Jun 2026 | 2 Jul 2026 | 31 days1 Jun to 2 Jul | $5,250.00 | $5,250.00 | $0.00 | Paid in full |
| 1107Row 68 | 1 Jul 2026 | 29 Jul 2026 | 28 days1 Jul to 29 Jul | $6,150.00 | $6,150.00 | $0.00 | Paid in full |
| 1117Row 78 | 3 Aug 2026 | 11 Sep 2026 | 39 days3 Aug to 11 Sep | $4,800.00 | $4,800.00 | $0.00 | Paid in full |
| 1126Row 87 | 1 Sep 2026 | 28 Sep 2026 | 27 days1 Sep to 28 Sep | $5,700.00 | $5,700.00 | $0.00 | Paid in full |
| Paid in full, 7 invoices | 228 days7 invoices added up | 32.6 days on average228 days ÷ 7 |
Harbor Point Dental, 9 invoices, 32.5 days on average, owes you $4,500.00
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1043Row 4 | 1 Jan 2026 | 2 Feb 2026 | 32 days1 Jan to 2 Feb | $4,950.00 | $4,950.00 | $0.00 | Paid in full |
| 1052Row 13 | 2 Feb 2026 | 2 Mar 2026 | 28 days2 Feb to 2 Mar | $5,100.00 | $5,100.00 | $0.00 | Paid in full |
| 1062Row 23 | 2 Mar 2026 | 6 Apr 2026 | 35 days2 Mar to 6 Apr | $4,350.00 | $4,350.00 | $0.00 | Paid in full |
| 1073Row 34 | 1 Apr 2026 | 11 May 2026 | 40 days1 Apr to 11 May | $4,650.00 | $4,650.00 | $0.00 | Paid in full |
| 1084Row 45 | 1 May 2026 | 1 Jun 2026 | 31 days1 May to 1 Jun | $4,800.00 | $4,800.00 | $0.00 | Paid in full |
| 1095Row 56 | 1 Jun 2026 | 1 Jul 2026 | 30 days1 Jun to 1 Jul | $4,200.00 | $4,200.00 | $0.00 | Paid in full |
| 1105Row 66 | 1 Jul 2026 | 4 Aug 2026 | 34 days1 Jul to 4 Aug | $4,350.00 | $4,350.00 | $0.00 | Paid in full |
| 1115Row 76 | 3 Aug 2026 | 2 Sep 2026 | 30 days3 Aug to 2 Sep | $4,500.00 | $4,500.00 | $0.00 | Paid in full |
| 1124Row 85 | 1 Sep 2026 | None | $4,500.00 | $0.00 | $4,500.00 | Open | |
| Paid in full, 8 invoices | 260 days8 invoices added up | 32.5 days on average260 days ÷ 8 | |||||
| Open, 1 invoice | $4,500.00 |
Larkspur Hotel Group, 4 invoices, 31 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1070Row 31 | 12 Mar 2026 | 13 Apr 2026 | 32 days12 Mar to 13 Apr | $12,000.00 | $12,000.00 | $0.00 | Paid in full |
| 1092Row 53 | 21 May 2026 | 10 Jun 2026 | 20 days21 May to 10 Jun | $12,000.00 | $12,000.00 | $0.00 | Paid in full |
| 1112Row 73 | 16 Jul 2026 | 31 Aug 2026 | 46 days16 Jul to 31 Aug | $12,000.00 | $12,000.00 | $0.00 | Paid in full |
| 1130Row 91 | 2 Sep 2026 | 28 Sep 2026 | 26 days2 Sep to 28 Sep | $12,000.00 | $12,000.00 | $0.00 | Paid in full |
| Paid in full, 4 invoices | 124 days32 + 20 + 46 + 26 | 31 days on average124 days ÷ 4 |
Ferro Tool & Die, 3 invoices, 29.3 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1059Row 20 | 20 Feb 2026 | 23 Mar 2026 | 31 days20 Feb to 23 Mar | $8,500.00 | $8,500.00 | $0.00 | Paid in full |
| 1081Row 42 | 23 Apr 2026 | 22 May 2026 | 29 days23 Apr to 22 May | $8,500.00 | $8,500.00 | $0.00 | Paid in full |
| 1102Row 63 | 9 Jun 2026 | 7 Jul 2026 | 28 days9 Jun to 7 Jul | $7,000.00 | $7,000.00 | $0.00 | Paid in full |
| Paid in full, 3 invoices | 88 days31 + 29 + 28 | 29.3 days on average88 days ÷ 3 |
Copperline Fitness, 2 invoices, 28 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1058Row 19 | 3 Feb 2026 | 3 Mar 2026 | 28 days3 Feb to 3 Mar | $6,500.00 | $6,500.00 | $0.00 | Paid in full |
| 1080Row 41 | 3 Apr 2026 | 29 May 2026 | $6,500.00 | $2,000.00 | $0.00 | Closed, not paid in full | |
| Paid in full, 1 invoice | 28 days | 28 days on average28 days ÷ 1 |
Tidewater Schools Foundation, 3 invoices, 26 days on average, owes you $3,000.00
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1091Row 52 | 7 May 2026 | 2 Jun 2026 | 26 days7 May to 2 Jun | $6,000.00 | $6,000.00 | $0.00 | Paid in full |
| 1111Row 72 | 3 Jul 2026 | 29 Jul 2026 | 26 days3 Jul to 29 Jul | $6,000.00 | $6,000.00 | $0.00 | Paid in full |
| 1121Row 82 | 19 Aug 2026 | 15 Sep 2026 | $5,500.00 | $2,500.00 | $3,000.00 | Part paid, open | |
| Paid in full, 2 invoices | 52 days26 + 26 | 26 days on average52 days ÷ 2 | |||||
| Open, 1 invoice | $3,000.00 |
Alder & Finch Law, 9 invoices, 17.6 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1045Row 6 | 1 Jan 2026 | 13 Jan 2026 | 12 days1 Jan to 13 Jan | $3,150.00 | $3,150.00 | $0.00 | Paid in full |
| 1054Row 15 | 2 Feb 2026 | 23 Feb 2026 | 21 days2 Feb to 23 Feb | $3,450.00 | $3,450.00 | $0.00 | Paid in full |
| 1065Row 26 | 2 Mar 2026 | 25 Mar 2026 | 23 days2 Mar to 25 Mar | $3,450.00 | $3,450.00 | $0.00 | Paid in full |
| 1076Row 37 | 1 Apr 2026 | 20 Apr 2026 | 19 days1 Apr to 20 Apr | $3,300.00 | $3,300.00 | $0.00 | Paid in full |
| 1087Row 48 | 1 May 2026 | 18 May 2026 | 17 days1 May to 18 May | $3,450.00 | $3,450.00 | $0.00 | Paid in full |
| 1098Row 59 | 1 Jun 2026 | 15 Jun 2026 | 14 days1 Jun to 15 Jun | $3,300.00 | $3,300.00 | $0.00 | Paid in full |
| 1108Row 69 | 1 Jul 2026 | 20 Jul 2026 | 19 days1 Jul to 20 Jul | $3,150.00 | $3,150.00 | $0.00 | Paid in full |
| 1118Row 79 | 3 Aug 2026 | 19 Aug 2026 | 16 days3 Aug to 19 Aug | $3,600.00 | $3,600.00 | $0.00 | Paid in full |
| 1127Row 88 | 1 Sep 2026 | 18 Sep 2026 | 17 days1 Sep to 18 Sep | $3,150.00 | $3,150.00 | $0.00 | Paid in full |
| Paid in full, 9 invoices | 158 days9 invoices added up | 17.6 days on average158 days ÷ 9 |
Oakwell Brewing, 2 invoices, 16.5 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1049Row 10 | 14 Jan 2026 | 26 Jan 2026 | 12 days14 Jan to 26 Jan | $4,000.00 | $4,000.00 | $0.00 | Paid in full |
| 1069Row 30 | 4 Mar 2026 | 25 Mar 2026 | 21 days4 Mar to 25 Mar | $4,500.00 | $4,500.00 | $0.00 | Paid in full |
| Paid in full, 2 invoices | 33 days12 + 21 | 16.5 days on average33 days ÷ 2 |
Willow Creek Senior Living, 6 invoices, 15.5 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1046Row 7 | 1 Jan 2026 | 15 Jan 2026 | 14 days1 Jan to 15 Jan | $5,550.00 | $5,550.00 | $0.00 | Paid in full |
| 1055Row 16 | 2 Feb 2026 | 26 Feb 2026 | 24 days2 Feb to 26 Feb | $5,100.00 | $5,100.00 | $0.00 | Paid in full |
| 1066Row 27 | 2 Mar 2026 | 9 Mar 2026 | 7 days2 Mar to 9 Mar | $5,400.00 | $5,400.00 | $0.00 | Paid in full |
| 1077Row 38 | 1 Apr 2026 | 20 Apr 2026 | 19 days1 Apr to 20 Apr | $6,600.00 | $6,600.00 | $0.00 | Paid in full |
| 1088Row 49 | 1 May 2026 | 19 May 2026 | 18 days1 May to 19 May | $6,450.00 | $6,450.00 | $0.00 | Paid in full |
| 1099Row 60 | 1 Jun 2026 | 12 Jun 2026 | 11 days1 Jun to 12 Jun | $6,150.00 | $6,150.00 | $0.00 | Paid in full |
| Paid in full, 6 invoices | 93 days6 invoices added up | 15.5 days on average93 days ÷ 6 |
Cascade Trail Outfitters, 9 invoices, 1.3 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1047Row 8 | 1 Jan 2026 | 2 Jan 2026 | 1 day1 Jan to 2 Jan | $2,850.00 | $2,850.00 | $0.00 | Paid in full |
| 1056Row 17 | 2 Feb 2026 | 3 Feb 2026 | 1 day2 Feb to 3 Feb | $3,300.00 | $3,300.00 | $0.00 | Paid in full |
| 1067Row 28 | 2 Mar 2026 | 3 Mar 2026 | 1 day2 Mar to 3 Mar | $3,300.00 | $3,300.00 | $0.00 | Paid in full |
| 1078Row 39 | 1 Apr 2026 | 3 Apr 2026 | 2 days1 Apr to 3 Apr | $3,150.00 | $3,150.00 | $0.00 | Paid in full |
| 1089Row 50 | 1 May 2026 | 2 May 2026 | 1 day1 May to 2 May | $2,700.00 | $2,700.00 | $0.00 | Paid in full |
| 1100Row 61 | 1 Jun 2026 | 3 Jun 2026 | 2 days1 Jun to 3 Jun | $3,000.00 | $3,000.00 | $0.00 | Paid in full |
| 1109Row 70 | 1 Jul 2026 | 4 Jul 2026 | 3 days1 Jul to 4 Jul | $2,850.00 | $2,850.00 | $0.00 | Paid in full |
| 1119Row 80 | 3 Aug 2026 | 4 Aug 2026 | 1 day3 Aug to 4 Aug | $2,850.00 | $2,850.00 | $0.00 | Paid in full |
| 1128Row 89 | 1 Sep 2026 | 1 Sep 2026 | 0 days1 Sep to 1 Sep | $3,450.00 | $3,450.00 | $0.00 | Paid in full |
| Paid in full, 9 invoices | 12 days9 invoices added up | 1.3 days on average12 days ÷ 9 |
Bramble Bakery, 9 invoices, 0.9 days on average
| InvoiceRow in your file | Issued | Last payment | Days to pay | Invoiced | Paid to you | Still owed to you | Counted as |
|---|---|---|---|---|---|---|---|
| 1048Row 9 | 1 Jan 2026 | 1 Jan 2026 | 0 days1 Jan to 1 Jan | $1,950.00 | $1,950.00 | $0.00 | Paid in full |
| 1057Row 18 | 2 Feb 2026 | 2 Feb 2026 | 0 days2 Feb to 2 Feb | $1,950.00 | $1,950.00 | $0.00 | Paid in full |
| 1068Row 29 | 2 Mar 2026 | 3 Mar 2026 | 1 day2 Mar to 3 Mar | $2,100.00 | $2,100.00 | $0.00 | Paid in full |
| 1079Row 40 | 1 Apr 2026 | 4 Apr 2026 | 3 days1 Apr to 4 Apr | $1,650.00 | $1,650.00 | $0.00 | Paid in full |
| 1090Row 51 | 1 May 2026 | 1 May 2026 | 0 days1 May to 1 May | $1,800.00 | $1,800.00 | $0.00 | Paid in full |
| 1101Row 62 | 1 Jun 2026 | 1 Jun 2026 | 0 days1 Jun to 1 Jun | $1,950.00 | $1,950.00 | $0.00 | Paid in full |
| 1110Row 71 | 1 Jul 2026 | 3 Jul 2026 | 2 days1 Jul to 3 Jul | $1,950.00 | $1,950.00 | $0.00 | Paid in full |
| 1120Row 81 | 3 Aug 2026 | 4 Aug 2026 | 1 day3 Aug to 4 Aug | $1,950.00 | $1,950.00 | $0.00 | Paid in full |
| 1129Row 90 | 1 Sep 2026 | 2 Sep 2026 | 1 day1 Sep to 2 Sep | $1,500.00 | $1,500.00 | $0.00 | Paid in full |
| Paid in full, 9 invoices | 8 days9 invoices added up | 0.9 days on average8 days ÷ 9 |
What this counts
- An invoice is paid in full when its Balance is 0 and its Paid Amount is at least its Invoice Amount. Its days to pay run from its Issue Date to its Last Payment Date.
- Days to pay are not days late. Harvest’s invoice export has no due date, so every invoice is counted from the day it was issued.
- An open invoice has a Balance above 0. One that is part paid counts in what its client still owes and in no average, because the export gives only the date of its last payment.
- Your other clients are every other client’s invoices paid in full, taken together, so a client with more invoices weighs more.
- The export has no status column, so a draft or a written-off invoice in the file would count as open. Tick only the Sent, Late and Paid statuses when you run the report, and neither is in it.
Also in your file
- 2 open invoices are part paid, so they count in what their clients still owe and in no average. Northline Freight, invoice 1104, $3,000.00 paid to you of $6,450.00, last on 21 Sep 2026. Tidewater Schools Foundation, invoice 1121, $2,500.00 paid to you of $5,500.00, last on 15 Sep 2026.
- 1 invoice was closed without being paid in full, a write-off in Harvest, so it is in no figure. Copperline Fitness, invoice 1080, $6,500.00 invoiced, $2,000.00 paid to you.
In Harvest, open Invoices, then Report, then New report. Choose Invoice report, your dates, and the Sent, Late and Paid statuses. Run it, then Export, then Export invoices to CSV or Excel.
No export to hand? Download our sheet to try it, or use it as a template. Swap our made-up rows for yours and drop it back in.