Make accounting Ledger using script / app in google spread sheet using spreadsheet database
$30-250 USD
Paid on delivery
Summary:
I have five sheets in 1 spread sheet with accounting entries as database. Based on database I want to generate a report in form of a ledger. Example of database is here
https://docs.google.com/spreadsheets/d/1O505Vq1hCvjJ86u0T6-BFrauptfPlnpwCeGGANftjvQ/edit#gid=2118023547
Details of project:
Sheet 1 details:
=============
Serial number: Auto
Date: User input
Dr Code: User input
Description of Dr code: Auto – should comes by script
Cr Code: User input
Description of Cr code: Auto – should comes by script
Quantity: User input
Rate: User input
Amount: Auto by simple multiplication
Remarks: User input
Cheque number: User input (Validation from sheet 4 and duplication not allowed)
User id: Auto – should comes by script based on google mail id.
Sheet 2 details (Similar as sheet 1 but on different sheet)
=============
Serial number: Auto
Date: User input
Dr Code: User input
Description of Dr code: Auto – should comes by script
Cr Code: User input
Description of Cr code: Auto – should comes by script
Quantity: User input
Rate: User input
Amount: Auto by simple multiplication
Remarks: User input
Cheque number: User input (Validation from sheet 4 and duplication not allowed)
User id: Auto – should comes by script based on google mail id.
Sheet 3 details:
============
Account Code: User input
Description: User input
Sheet 4 details:
=============
Date – User input
Dr Code – User input
Cr Code – User input
Qty – User input
Rate – User input
Amount – auto by simple multiplication
Date – User input
Dr Code – User input
Cr Code – User input
Qty – User input
Rate – User input
Amount – auto by simple multiplication
Date – User input
Dr Code – User input
Cr Code – User input
Qty – User input
Rate – User input
Amount – auto by simple multiplication
Date – User input
Dr Code – User input
Cr Code – User input
Qty – User input
Rate – User input
Amount – auto by simple multiplication
Sheet 5:
Cheque number
Bank Name
Report:
On entering account code, script should generate a ledger (Report) from sheet 1/2/3/4 sorted by date
Fields of Ledger
[login to view URL]
Date
Qty
Rate
Particulars
Dr amount
Cr amount
Balance – (arrives from calculation)
Remarks
Some headers and footers from calculations
All database Sheet1-5 should have limited / full access as admin decides.
ranges on sheets should be locked by time driver trigger which would restrict user to further edit certain ranges based on dates
I am open here for discussion
Project ID: #10181907
About the project
Awarded to:
Hello, I have good Google apps script experience and have dealt with many Google spread sheet project. You request is doable and can deliver it in quickly. Best regards.
8 freelancers are bidding on average $192 for this job
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More
