{"id":10500,"date":"2019-07-24T11:15:03","date_gmt":"2019-07-24T11:15:03","guid":{"rendered":"https:\/\/intranet-old.colart.com\/en\/?page_id=10500"},"modified":"2022-01-26T14:03:17","modified_gmt":"2022-01-26T14:03:17","slug":"reports-finance","status":"publish","type":"page","link":"https:\/\/intranet-old.colart.com\/en\/business-analytics-home\/mrc\/reports-finance\/","title":{"rendered":"Reports – Finance"},"content":{"rendered":"
\n
\n
\n\t\t\t

Business Analytics<\/span><\/h1>\n\t\t\t\t\t\t

Finance<\/span><\/h2>\n\t\t\t\t\t\t <\/div>\n <\/div>\n<\/section>\n<\/div><\/div><\/div>
\n
\n\t\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nDescription<\/th>\nType<\/th>\nOwner<\/th>\n<\/tr>\n
Doubtful Debt Details (ARS130)<\/a><\/td>\nThis report returns the invoice details of the aged accounts receivables that have been amortized as doubtful accounts through ARS130. It will show the payer, invoice number, invoice date, invoice due date, total invoice amount, if it is a debit or credit balance, tax amount, amount still currently opened in AR, the doubtful allowance depreciation rate, the amount that has been previously provisioned, and the difference between what has previously been provisioned and what is provisioned now.<\/td>\nReport<\/td>\nStephanie Casertano<\/td>\n<\/tr>\n
FIN _ Aged AP Report<\/a><\/td>\nThis is a graph view showing Accounts Payable with Total not due and Total Overdue<\/td>\nReport<\/td>\nPhilippe Chauvin<\/td>\n<\/tr>\n
Fixed Asset Transactions<\/a><\/td>\nThis report will give you the amounts of a certain transaction type, and should be used for questions like how much did we acquire over the last period, or which assets were disposed of over a certain period, or which ones did we sell, etc.<\/td>\nReport<\/td>\nStephanie Casertano<\/td>\n<\/tr>\n
Goods Received, not invoiced<\/a><\/td>\nThis report is used to reconcile our GRNI suspense account<\/td>\nReport<\/td>\nDale Drake<\/td>\n<\/tr>\n
ITA - Cliente<\/a><\/td>\nThis is a report for Spesometro and Esterometro declarations for Italy Cliente<\/td>\nReport<\/td>\nPierre Grosbois<\/td>\n<\/tr>\n
ITA - EU Invoices<\/a><\/td>\nThis is a report for Spesometro and Esterometro declarations for Italy EU Invoices<\/td>\nReport<\/td>\nPierre Grosbois<\/td>\n<\/tr>\n
ITA - Fornitore<\/a><\/td>\nThis is a report for Spesometro and Esterometro declarations for Italy Fornitore<\/td>\nReport<\/td>\nPierre Grosbois<\/td>\n<\/tr>\n
ITA - San Marino<\/a><\/td>\nThis is a report for Spesometro and Esterometro declarations for Italy San Marino<\/td>\nReport<\/td>\nPierre Grosbois<\/td>\n<\/tr>\n
ITA Invoice Commission Report<\/a><\/td>\nThis is a commissions report by month and Quarter. \u2013 MTH\/Q<\/td>\nReport<\/td>\nPierre Grosbois<\/td>\n<\/tr>\n
M3 Supplier Bank Details - Audit Changes<\/a><\/td>\nThis highlighted Suppliers which have been changed, and by whom.<\/td>\nRetrieval<\/td>\nPhilippe Chauvin<\/td>\n<\/tr>\n
Customer Bank Details - Audit Changes<\/a><\/td>\nThis highlighted Customers which have been changed, and by whom.<\/td>\nReport<\/td>\nPhilippe Chauvin<\/td>\n<\/tr>\n
PO Lines Details<\/a><\/td>\nThis report gives Purchase order line details, including cost center and Project number.<\/td>\nReport<\/td>\nFelicity Hullah<\/td>\n<\/tr>\n
PPS Analysis<\/a><\/td>\nThis report is used to obtain the quantity of products received from DC1 by transaction date. This is filtered on the transaction ID of 'PPS'<\/td>\nReport<\/td>\nStephanie Orain<\/td>\n<\/tr>\n
TXS130<\/a><\/td>\nThis is an EC Sales report, used to reconcile the EC Sales data submissions.<\/td>\nReport<\/td>\nDale Drake<\/td>\n<\/tr>\n
Vat Details (TXS100) - Sales<\/a><\/td>\nThis is a VAT report, used to complete and reconcile vat runs<\/td>\nReport<\/td>\nDale Drake<\/td>\n<\/tr>\n
VAT Details (TXS100) - Errors on VAT receivables account<\/a><\/td>\nThese reports are linked to Vat Details (TXS100) - Sales<\/td>\nReport<\/td>\nDale Drake<\/td>\n<\/tr>\n
VAT Details (TXS100) - VAT differences sales<\/a><\/td>\nThese reports are linked to Vat Details (TXS100) - Sales<\/td>\nReport<\/td>\nDale Drake<\/td>\n<\/tr>\n
VAT Details (TXS100) - Errors on VAT payables account<\/a><\/td>\nThese reports are linked to Vat Details (TXS100) - Sales<\/td>\nReport<\/td>\nDale Drake<\/td>\n<\/tr>\n
VAT Details (TXS100) - VAT differences purchases<\/a><\/td>\nThese reports are linked to Vat Details (TXS100) - Sales<\/td>\nReport<\/td>\nDale Drake<\/td>\n<\/tr>\n
General Ledger Audit File<\/a><\/td>\nThis report is the list of detailed deliveries per customer , including delivery number, invoice number, date of delivery and value of delivery<\/td>\nReport<\/td>\nPatricia Le Mauff<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div><\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"

Name Description Type Owner Doubtful Debt Details (ARS130) This report returns the invoice details of the aged accounts receivables that have been amortized as doubtful accounts through ARS130. It will show the payer, invoice number, invoice date, invoice due date, total invoice amount, if it is a debit or credit balance, tax amount, amount still […]<\/p>\n","protected":false},"author":280,"featured_media":0,"parent":9663,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"colart_campaign":[],"class_list":["post-10500","page","type-page","status-publish","hentry","post"],"acf":[],"_links":{"self":[{"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages\/10500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/users\/280"}],"replies":[{"embeddable":true,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/comments?post=10500"}],"version-history":[{"count":7,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages\/10500\/revisions"}],"predecessor-version":[{"id":25732,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages\/10500\/revisions\/25732"}],"up":[{"embeddable":true,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/pages\/9663"}],"wp:attachment":[{"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/media?parent=10500"}],"wp:term":[{"taxonomy":"colart_campaign","embeddable":true,"href":"https:\/\/intranet-old.colart.com\/en\/wp-json\/wp\/v2\/colart_campaign?post=10500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}