Đang Thực Hiện

Update design of double entry accounting system

This project is to design additional tables for a relational database in a double entry accounting system, and answer a few implementation questions.

The scope of this project DOES NOT include the effort to create the database tables.

Your work will help us to integrate our custom business management system with a custom accounting system. We are working towards migrating from QuickBooks to this new system.

The deliverables are:

1) a document describing the new tables, columns, data types and relationships

2) a document with the new use cases for all the accounting functions that can be performed using the new tables (and state the associated tables used to perform the action)

3) a document with answers to the implementation questions asked in this scope of work

Background:

Machines are rented to customers. At the end of each day, every machine sends their current meter (this is a usage count, like an odometer), and this information is logged into a database. At the end of the billing period, customer usage is calculated by subtracting the meter at the end of the month from the meter at the beginning of the month. The customer is then invoiced for the actual usage during the month.

See an attachment for an example invoice.

See an attachment for an example database table with the machine meters sent daily.

Here are the details for the new tables and the questions to be answered (the scope of work):

1) Design the table(s) necessary and write the use cases for automatically generating a usage-based invoice at the end of each billing period.

The design and use cases must accommodate these scenarios:

a) calculate the usage since the last billing period, and it to the invoice

b) add a line item to provide the customer some credit for free usage (note: allow an admin to add or specify the credit somewhere in the database earlier in the month)

c) add a line item for a fixed rent price

d) add line items for any consumables sent to the customer during the billing period

e) add other charges that accumulate during the month, such as a late fee

2) Document how to account for Stockholder's Equity. There are two ways the Stockholder's Equity accumulates right now. First, the owner injects cash into the business by making a cash deposit into the business bank account. Second, the owner purchases items or services for the business with their personal credit card, and it is treated as a credit to the Stockholder's Equity. This is likely not a new accounting table. The answer to this question likely may be a few use cases.

3) Document how to generate a report for payments to vendors made via both the AP table and Stockholder’s Equity. Right now, reports for showing the spending per vendor only show things that flowed through the AP table.

4) Should the Module Codes be hardcoded or placed in a database table? Please justify your answer.

In your bid/proposal, please describe your previous experience with 1) accounting software and 2) database design.

Kĩ năng: Kế toán, Phát triển cơ sở dữ liệu, ERP, SQL

Xem nhiều hơn: accounting software banner design, double entry accounting lesson plan, web based double entry accounting php, accounting for developers, double entry accounting php, accounts table structure, double entry accounting database design, database design for accounting and business applications, debit credit database design, double entry accounting database structure sql server, database technology and double entry accounting, double entry bookkeeping accounting lesson plans, gujarat double entry accounting, chartered accountants double entry accounting work, double entry accounting, double entry accounting can excel, double entry accounting net code, double entry accounting tally, tally double entry accounting software, double entry system accounting software source code

Về Bên Thuê:
( 4 nhận xét ) Oswego, United States

ID dự án: #18447891

Được trao cho:

WynandDuToit

Good day I will design the additional tables and corresponding use cases to integrate with existing accounting database design. Will also answer and motivate additional questions arising from this.

$388 USD trong 10 ngày
(1 Nhận xét)
3.0

19 freelancer đang chào giá trung bình $197 cho công việc này

RRconsultant

Greetings! I am keen to help you with the requirements. Look forward to hear from you. Thanks, RRC

$250 USD trong 10 ngày
(68 Nhận xét)
6.4
kashivw

Hello, I am a veteran (25+ years) database developer with real industry experience in database design, development and migration. I am well-experienced with Oracle (v6 thru v12c), SQL Server (v7 thru 17), MySQL (4.x Thêm

$200 USD trong 5 ngày
(9 Nhận xét)
4.4
jssymm

We have rich experience in design, development and implementation of financial and business applications at various levels of complexity. Our proprietary, web-based multi-dimensional ERP for non-profits is being used b Thêm

$250 USD trong 15 ngày
(2 Nhận xét)
4.2
writinginvaderz

I am professional graphic designer,have experience of 3 years in this [login to view URL] me for design your desired items.I can design these items, listed below *Logo design *Business card design *Flyer & brochures Thêm

$222 USD trong 3 ngày
(1 Nhận xét)
3.2
GopalJp

Hi, I would like to offer you my services for your project Update design of double entry accounting system. I am an Accountant and Microsoft Excel Expert including VBA or Macros development. I perform variety of Thêm

$50 USD trong 3 ngày
(9 Nhận xét)
3.3
rebeccasardoma

Hi, Further to your recent job post ''Update design of double entry accounting system", I would like to be considered for this vacancy. After reading the job description for this position, I believe that my ex Thêm

$155 USD trong 3 ngày
(8 Nhận xét)
2.9
$444 USD trong 15 ngày
(0 Nhận xét)
0.0
sathishraja510

155 USD Relevant Skills and Experience I am handling AR [login to view URL] MIS report like Trial balance,P and L , Balance Sheet and cash flow. And Automatically generated Sales voucher through invoice making

$155 USD trong 3 ngày
(0 Nhận xét)
0.0
siddaharsh

hi, I am an experienced account working since 2016 in accounting field along with my CA studies. as I m already working with several clients providing services like establishing their business, accounting standards set Thêm

$224 USD trong 20 ngày
(0 Nhận xét)
0.0
adesh966

Hi there, I am a qualified Indian Chartered Accountant having 2.5 year of post qualification experience in the field of accounting, auditing and taxation. I have served 200+ happy client in Madhya Pradesh in INDIA i Thêm

$211 USD trong 12 ngày
(0 Nhận xét)
0.0
EngMarram

I am veryyy good really Relevant Skills and Experience Sql, oracle, C#

$222 USD trong 4 ngày
(0 Nhận xét)
0.0
$155 USD trong 3 ngày
(0 Nhận xét)
0.0
CASachin1

I understand exactly what you’re looking for, To brief you about my Qualification and Experience i am sharing my LinkedIn profile : [login to view URL] I am a Chartered Thêm

$40 USD trong 5 ngày
(0 Nhận xét)
0.0
conormarjoram

Hi , happy new year i would be very interested to work on your accounting project i'm available to discuss immediately, kindest regards Conor

$155 USD trong 3 ngày
(0 Nhận xét)
0.0
carohitarora072

Dear Sir, after going through your requirements for work, I Rohit Arora a Practicing Chartered Accountant propose to undertake your assignment and assure you to provide my services with accuracy & timely. Our team has Thêm

$155 USD trong 3 ngày
(0 Nhận xét)
0.0
$155 USD trong 3 ngày
(0 Nhận xét)
0.0
angong

as a well qualified accountant with more than 4 years of experience working with complex data and producing quality results, i believe am going to give you just what you need at the right time frame

$155 USD trong 3 ngày
(0 Nhận xét)
0.0
Work4ashish

Hi, I have been working in accounts & taxation for USA, UK based companies for 13 years. I am core member in my company for my knowledge cum work. Seek your positive reply. Thanks

$155 USD trong 3 ngày
(0 Nhận xét)
0.0