Find Jobs
Hire Freelancers

Zoho Analytics Query Table project

$10-30 USD

종료됨
게시됨 약 1년 전

$10-30 USD

제출할때 지불됩니다
TASK 1 I have revenue contracts with customers which we invoice every month. In Zoho Analytics, I have synced with Zoho Books and created a data table with a list of “recurring invoices”. I then created a new query table to show the customer ID, contract start date (“Start Date”) and invoice amount (“Total (BCY)”). Using this query table, I want to create a list of all monthly invoices (showing customer ID, invoice date and invoice amount, including future invoices) from the contract start date through the end of year 2025 (assuming all the contracts are active until then) for each customer. TASK 2 I have revenue contracts with customers which we invoice at a certain payment frequency (1 month / 3 months / 6 months / 1 year) over a 36 month contract period. In Zoho Analytics, I have synced with Zoho Books and created a data table with a list of “recurring invoices”. I then created a new query table to show the customer ID, contract start date (“Start Date”), invoice amount (“Total (BCY)”) and Recurrence Frequency. Using this query table, I want to create a list of all invoices (showing customer ID, invoice date and invoice amount, including future invoices) from the contract start date through the end of each 36 month contract for each customer.
프로젝트 ID: 36477532

프로젝트 정보

10 제안서
원격근무 프로젝트
활동 중 1년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
10 이 프로젝트에 프리랜서들의 평균 입찰은 $118 USD입니다.
사용자 아바타
Dear Hiring Manager, I am writing to express my interest in the role of a Data Analyst in your organization. As a highly skilled and experienced analyst, I am confident that my abilities and experience make me a perfect fit for the position. With my proficiency in Zoho Analytics, I can efficiently extract data and manipulate it to suit business needs. Specifically, I have experience working on revenue contracts with customers and syncing data from Zoho Books. Using Zoho Analytics, I have created data tables and query tables to extract critical information needed to track monthly and recurring invoices. For Task 1, I can create a list of monthly invoices from contract start date to the end of 2025 for each customer. And for Task 2, I can generate a list of invoices, including future ones, from the contract start date to the end of each 36-month contract period. I am highly organized, detail-oriented, and a team player, making me efficient in meeting project deadlines and producing quality work. With my excellent communication skills, I can explain technical concepts and analyses to both technical and non-technical team members. I am excited about the opportunity to bring my skills and experience to your organization. Thank you for considering my application. Sincerely, Diana Jane
$500 USD 7일에
4.9 (2 건의 리뷰)
4.8
4.8
사용자 아바타
Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Zoho Please come over chat and discuss your requirement in a detailed way. Thank You
$14 USD 2일에
5.0 (3 건의 리뷰)
3.7
3.7
사용자 아바타
Hi there, I have checked your job description and it is matching with my skills. I am interested to do the work with you. I'm a Zoho expert, having 6 years of experience in the web and all Zoho Products. My Expertise is mentioned below: Integration : SAAS:-Zoho CRM with Zoho Creator, Zoho Books, Zoho Invoices, Zoho Analytics, Zoho Campaign, and vice versa. CMS:- WordPress, Mailchimp Integration, Custom Theme, Plugin, Quickbooks. Payment Gateway:- PayPal and Stripe. Telephony:- RingCentral, Twilio, and other phone-based integrations. Email Suit:-Zoho Mail with Gmail, MS Office 365, Automation: Workflow rules, Autoresponders, Email Templates Creation,and Custom functions Automatic Rules, Reminder Setup, and Notification via Email and SMS. Dashboard and Report Creation. Webhooks calls. I will give support for any kind of bugs/fixes. This states that I will be more attentive during the project and post-production support. Thank you and I look forward to the opportunity to work with you
$80 USD 4일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
After reading your request. I wanted to let you know a few things. Zoho Analytics only works with predefined data fields in the other zoho modules and only data that's currently in the system. It can't project. I can make up a custom deluge script in books(customer button) that could calculate and create a report that is emailed to you. It can not give invoice numbers though as that is a system generated realtime. it can give everything else that you want(invoice date, amount, freq.). I would also recommend setting up your clients with recurring invoices as then the system can send out billing per your requested times automatically no matter what the frequency is. This project will take a couple of days to setup, build, and test. Can we talk on friday to discuss more about your project. All the Best, Gabriel
$200 USD 7일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED STATES)
Nishinomiya, United States
0.0
0
4월 28, 2023부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.