Descripción del proyecto
We will consider development based on Access, Excel, 1C, development of a program with 0, with the following functionality:
1. Bank statements of 1c format (sent by customers) are downloaded in batch.
2. Make a separation of transactions by customers and debit, credit in automatic mode (based on tables of substitutions)
3. Manually make the missing customers through the form.
4. Calculate the profit from each debit, credit transaction (calculated in percentage shares), the profit received shall be entered into our account.
5. Report to the client about the transactions.
The program should reflect exactly Management accounting, simple and visual, at the level came - gone, but for each incoming or expenditure transaction, it is necessary to fix data on the payment order. And it is imperative to observe the principle of double entry.
The programme should be structured as follows:
1. The balance or total account of the client. (A bank account consisting of several bank accounts of one and/or several of the client’s firms)
2. Our balance or account in which income falls - interest in monetary terms from client operations, other income, our expenses for maintaining the company, etc.
3. Cash account (cash register)
4. The analytics unit.
Provide for the possibility of expanding the functionality of the program.
Features of the functionality:
1. Operations should not be duplicated, i.e. For example, the purchase of lumber for 100,000 rubles. With payment order No. 57 of 01.06.2015 should not appear in the database twice.
2. Provide for the settlement account work of several clients. I mean. Let us assume on account 0000000000000000000 order on payment order No 57 of 01.06.2015 gives the client "XXX", and the order on payment order No 58 of 02.06.2015 gives the client "YYY", such situations sometimes arise, they are associated with offsets between customers. The same conditions for incoming operations.
1. Bank statements of 1c format (sent by customers) are downloaded in batch.
2. Make a separation of transactions by customers and debit, credit in automatic mode (based on tables of substitutions)
3. Manually make the missing customers through the form.
4. Calculate the profit from each debit, credit transaction (calculated in percentage shares), the profit received shall be entered into our account.
5. Report to the client about the transactions.
The program should reflect exactly Management accounting, simple and visual, at the level came - gone, but for each incoming or expenditure transaction, it is necessary to fix data on the payment order. And it is imperative to observe the principle of double entry.
The programme should be structured as follows:
1. The balance or total account of the client. (A bank account consisting of several bank accounts of one and/or several of the client’s firms)
2. Our balance or account in which income falls - interest in monetary terms from client operations, other income, our expenses for maintaining the company, etc.
3. Cash account (cash register)
4. The analytics unit.
Provide for the possibility of expanding the functionality of the program.
Features of the functionality:
1. Operations should not be duplicated, i.e. For example, the purchase of lumber for 100,000 rubles. With payment order No. 57 of 01.06.2015 should not appear in the database twice.
2. Provide for the settlement account work of several clients. I mean. Let us assume on account 0000000000000000000 order on payment order No 57 of 01.06.2015 gives the client "XXX", and the order on payment order No 58 of 02.06.2015 gives the client "YYY", such situations sometimes arise, they are associated with offsets between customers. The same conditions for incoming operations.
Desarrollo de software Efectivo, Transferencia bancaria, Dinero electrónico
