Update design of double entry accounting system

En curso Publicado hace 5 años Pagado a la entrega
En curso Pagado a la entrega

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.

Contabilidad Desarrollo de base de datos ERP SQL

Nº del proyecto: #18447891

Sobre el proyecto

18 propuestas Proyecto remoto Activo hace 5 años

18 freelancers están ofertando un promedio de $186 por este trabajo

RRconsultant

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

$250 USD en 10 días
(103 comentarios)
7.3
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 Más

$50 USD en 3 días
(34 comentarios)
6.0
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 Más

$155 USD en 3 días
(11 comentarios)
5.6
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 Más

$200 USD en 5 días
(13 comentarios)
4.9
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 Más

$250 USD en 15 días
(2 comentarios)
4.2
EngMarram

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

$222 USD en 4 días
(0 comentarios)
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 en 3 días
(0 comentarios)
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 en 3 días
(0 comentarios)
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 Más

$155 USD en 3 días
(0 comentarios)
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 Más

$211 USD en 12 días
(0 comentarios)
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 Más

$224 USD en 20 días
(0 comentarios)
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 en 3 días
(0 comentarios)
0.0