Feature: Process settlements to make service tax filing easier

[shreyas-satish]

As per India's service tax regulations, an organization must file its service tax returns on or before the 5th of every month. Filing service tax returns requires the following process to be done:

1. Importing settlements (payments made by the payment gateway to the organization) from the organization's payment gateway(s).
2. Preparing a report consisting of detailed break-ups of each settlement i.e details of the orders, line items and transactions that constituted a particular settlement. The report also confirms if the settled amount tallies with the transactions recorded on Boxoffice.

Boxoffice only supports integrating with Razorpay at the moment, and Razorpay, does not have an API for settlements. So, the above process has been carried out so far, by downloading CSV reports from Razorpay's dashboard and running a script to prepare the report (as described in 2). This is cumbersome because, it requires the accountant to depend on the developer for these time-sensitive reports.

Boxoffice, should thus, provide a feature on the dashboard, which will allow the accountant to upload settlement reports (obtained from the payment gateway) and export the processed report.

The report should consist of two main documents. The first document should provide the list of orders that make up each settlement and it should consist of the following fields:

1. entity_id: The unique id of the payment, refund, adjustment or settlement as per the payment gateway.
2. settlement_id: The unique id of the settlement, as per the payment gateway.
3. order_id: The unique id of the order on boxoffice.
4. buyer_fullname: Full name of the buyer.
5. credit: The amount that the organization received from the payment gateway, after service charges and taxes being deducted.
6. debit: The amount the
7. fee: Service charges + taxes
8. receivable_amount: transaction_amount - fee
9. transaction_amount: The amount as per the transaction in boxoffice.
10. settlement_date: Date on which the payment gateway made the settlement.
11. transaction_date: Date on which the transaction happened.

The second document should detail the line items that make up each order, and should consist of the following fields:

1. line_item_id
2. item_title: Title of the item purchased
3. item_collection_title: Title of the item collection
4. final_amount: Amount charged for the line_item.
5. order_id: The id of the order to which the line item belongs.
6. tag: eg: the name of the event.

[shreyas-satish]

This was implemented in #184.