Spreadsheet: 693768d1599142168-sum-up-by-day-currency-and-category-rec-template
Sheet: Data

CoCode | G/L | User name | DocumentNo | Type | PK | Clrng doc. | Text | Assignment | Amount in doc. curr. | Doc. Date | Curr. | Amount in loc.curr.2 | LCur2 | Pstng Date | GL | Category | Mapping
3300 | 111111 | JOE | 2000010742 | ZR | 1 | 100 | ABC | [PHONE] | 22264202 | 2020-08-31 00:00:00 | [NAME] | 160747.54 | GBP | 2020-08-31 00:00:00 | 111111 | In house Payroll Control | IP Net Pay
3300 | 111111 | JOE | 2000010744 | ZR | 2 | 101 | ABC | [PHONE] | 9749990 | 2020-08-31 00:00:00 | [NAME] | 70394.93 | GBP | 2020-08-31 00:00:00 | 111111 | Pension Control account | IP Other
3300 | 111111 | JOE | 2000010626 | ZR | 3 | 102 | ABC | [PHONE] | 7350320 | 2020-08-06 00:00:00 | [NAME] | 53069.31 | GBP | 2020-08-06 00:00:00 | 111111 | [NAME] | Tax VAT
3300 | 111111 | JOE | 2000010612 | ZR | 4 | 103 | ABC | [PHONE] | 6443950 | 2020-08-03 00:00:00 | [NAME] | 46525.32 | GBP | 2020-08-03 00:00:00 | 111111 | Creditors - Non Trade | APNT Vendor
1106 | 111111 | JOE | 2000013670 | ZR | 5 | 104 | ABC | [PHONE] | 4801319.73 | 2020-08-20 00:00:00 | USD | 3669648.67 | GBP | 2020-08-20 00:00:00 | 111111 | ECM PAYE Contractors Control | ECM
1106 | 111111 | JOE | 2000013578 | ZR | 6 | 105 | ABC | [PHONE] | 4712613.66 | 2020-08-06 00:00:00 | USD | 3601850.62 | GBP | 2020-08-06 00:00:00 | 111111 | ECM PAYE Contractors Control | ECM
3300 | 111111 | JOE | 2000010688 | ZR | 7 | 106 | ABC | [PHONE] | 2821136 | 2020-08-21 00:00:00 | [NAME] | 20368.6 | GBP | 2020-08-21 00:00:00 | 111111 | Creditors - Non Trade | APNT Vendor
0723 | 111111 | JOE | 2000010312 | ZR | 8 | 107 | ABC | [PHONE] | 2318234.53 | 2020-08-28 00:00:00 | EUR | 2086503.81 | GBP | 2020-08-28 00:00:00 | 111111 | In house Payroll Control | IP Net Pay
3300 | 111111 | JOE | 2000010656 | ZR | 9 | 108 | ABC | [PHONE] | 1980000 | 2020-08-13 00:00:00 | [NAME] | 14295.6 | GBP | 2020-08-13 00:00:00 | 111111 | Creditors - Trade | APT
3300 | 111111 | JOE | 2000010736 | ZR | 10 | 109 | ABC | [PHONE] | 1973000 | 2020-08-31 00:00:00 | [NAME] | 14245.06 | GBP | 2020-08-31 00:00:00 | 111111 | Income Tax | IP Tax
0100 | 111111 | JOE | 2001136623 | ZR | 11 | 110 | ABC | [PHONE] | 1912481.85 | 2020-08-07 00:00:00 | GBP | 1912481.85 | GBP | 2020-08-07 00:00:00 | 111111 | Creditors - Trade | APT
0100 | 111111 | JOE | 2001139249 | ZR | 12 | 111 | ABC | [PHONE] | 1895878.39 | 2020-08-21 00:00:00 | GBP | 1895878.39 | GBP | 2020-08-21 00:00:00 | 111111 | Creditors - Trade | APT
3300 | 111111 | JOE | 2000010657 | ZR | 13 | 112 | ABC | [PHONE] | 1860983 | 2020-08-13 00:00:00 | [NAME] | 13436.3 | GBP | 2020-08-13 00:00:00 | 111111 | Creditors - Trade | APT
0100 | 111111 | JOE | 2001137924 | ZR | 14 | 113 | ABC | [PHONE] | 1812220.6 | 2020-08-14 00:00:00 | GBP | 1812220.6 | GBP | 2020-08-14 00:00:00 | 111111 | Creditors - Trade | APT
0100 | 111111 | JOE | 2001140612 | ZR | 15 | 114 | ABC | [PHONE] | 1782984.69 | 2020-08-28 00:00:00 | GBP | 1782984.69 | GBP | 2020-08-28 00:00:00 | 111111 | Creditors - Trade | APT
0722 | 111111 | JOE | 2000001125 | ZR | 16 | 115 | ABC | [PHONE] | 1764735.81 | 2020-08-14 00:00:00 | EUR | 1588332.82 | GBP | 2020-08-13 00:00:00 | 111111 | [NAME] | Tax VAT
3300 | 111111 | JOE | 2000010708 | ZR | 17 | 116 | ABC | [PHONE] | 1550657 | 2020-08-27 00:00:00 | [NAME] | 11195.74 | GBP | 2020-08-27 00:00:00 | 111111 | Creditors - Trade | APT
3300 | 111111 | JOE | 2000010737 | ZR | 18 | 117 | ABC | [PHONE] | 1502270 | 2020-08-31 00:00:00 | [NAME] | 10846.39 | GBP | 2020-08-31 00:00:00 | 111111 | Income Tax | IP Tax
1102 | 111111 | JOE | 2000210886 | ZR | 19 | 118 | ABC | [PHONE] | 1472035.82 | 2020-08-27 00:00:00 | USD | 1125076.98 | GBP | 2020-08-27 00:00:00 | 111111 | In house Payroll Control | IP Net Pay
3300 | 111111 | JOE | 2000010741 | ZR | 20 | 119 | ABC | [PHONE] | 1434306 | 2020-08-31 00:00:00 | [NAME] | 10355.69 | GBP | 2020-08-31 00:00:00 | 111111 | ECM PAYE Contractors Control | ECM