In Progress

Tableau - Reconciliation statement

I have attached an excel file.

It is a reconciliation of vendor statement.

There is one input name Foreign which is vendor statement of accounts.

Only items which do not have any value in the clearing doc. will be considered for reconciliation.

All the other excel sheets are inputs for India books.

Again only items without clearing doc. should be cleared.

The field doc no. in Vendor sheet and Reference in India are common fields.

Columns M to T in vendor statement are only for reconciliation. They are not actual inputs

Similarly columns M and N are only for reconciliation. They are not actual inputs.

Reconciliation is done as follows:

1. Reference field from India is matched with Doc no. with foreign. If the vales match, there is no difference. This will not be part of reconciliation.

2. If the invoice no. is matching, but difference in value, the difference will be part of reconciliation.

3. If the invoice no. is matching but one of the account is not cleared(i.e. Clearing doc is blank for one and has a number in another), this will also appear as a reconciliation with the remark 'Already cleared'

4. If the invoice no. is not available in 'India', then the invoice no. is foreign is compared with invoice no. in all other sheets in the below order.

a. Managing committee

b. GRN made

c. Gate entry

d. GIT

e. BOE

f. wrong invoice no.

In the case of any clarification, please ping me for details.

Skills: Tableau

See more: philippines bureau internal revenues bank reconciliation statement, reconciliation statement preparation government account, i need 4 medicine, i need someone to convert this page from psd to fully editable html i have homepage already so most coding like header + footer , i need someone to convert this page from psd to fully editable html i have homepage already so most coding like header footer is, i need a phd research proposal writer who can write 3 4 research proposals on potential phd research topics in the following are, who wrote the statement i see i remember in the academic books, I have 4 years experience in writing and publishing academic papers. Trust me to deliver a masterpiece on this order. I have mas, Bank reconciliation statement 2, how to make bank reconciliation statement in excel format, tableau financial statement dashboard, party reconciliation statement in excel, reconciliation statement, how to prepare bank reconciliation statement, bank reconciliation statement format, how to prepare bank reconciliation statement in excel pdf, bank reconciliation statement, bank reconciliation statement tips and tricks, bank reconciliation statement rules, i care 4 u values pdf

About the Employer:
( 1 review ) porur, India

Project ID: #24846788

Awarded to:

bgreddycs

1.I have 5 years of experience in BI Tools Tableau,Spotfire,Power bi,Altetyx. [login to view URL] knowledge in creating reports dashboards ,Score cards and Story using Tableau desktop. [login to view URL] knowledge in Tableau server,onlin More

₹1250 INR in 1 day
(4 Reviews)
1.9

4 freelancers are bidding on average ₹1563 for this job

fastlabindia

Greeting!. Yours work is one of the tasks that can be done very perfectly by us. We work within your budget, Within your deadline. We are highly experienced Post Graduate Engineers, IT, ITES, Software, Infrastructure P More

₹3000 INR in 2 days
(1 Review)
1.6
syed2u

Hi; only one clarification in your sheet Is document No referring invoice No. Thanks & Regards Syed Shareq

₹1000 INR in 3 days
(0 Reviews)
0.0
ajaybansal1995

Hi, I have 1.5 years experience in advance excel and tableau with expertise in data visualization, interactive dashboard creation and LOD expression. I have understood your business requirement. Kindly connect on chat More

₹1000 INR in 3 days
(1 Review)
0.0