Questions tagged [accounting]
Systematic recording, reporting, and analysis of financial transactions of a business.
300
questions
-1
votes
1answer
24 views
Double entry accounting: data types for efficiency? [closed]
Started designing databases very recently. I am wondering if I chose the right data types.
For example, I was told to use integers for $ amounts to avoid troubles. Also for tax rates I put decimals, I ...
0
votes
0answers
29 views
VAT accounting: 14 day rule - can't get to balance
How do you account for this, when the Invoice Date is > 14 days after the date of Supply?
I understand that generally, the Tax Point Date (when VAT should be recognised) is the earlier of the ...
0
votes
0answers
10 views
How to pull email addresses from Sage50
Is there a way to pull all the email addresses ever entered from Sage50?
I have tried report designer and csv export, to no avail.
I can export a huge number of phone numbers, but would ideally like ...
0
votes
0answers
16 views
How to compute a time weighted management fee based on differing contribution dates?
I have a list of investors with different contribution dates, how do I compute the fee based on their dates of contribution?
This is what I want it to look like, but not with having this gigantic ...
0
votes
0answers
38 views
SQL Total sum in nested CTE
I have to query general ledger BalanceSheet, but with a pre-defined table structure,where i have subtotals for each group of parentIds and GrandTotal for each mod (Assets and liabilities) as follow:
...
0
votes
0answers
11 views
Save button won't update list of contacts
I'm currently following this tutorial https://docs.microsoft.com/en-us/aspnet/web-api/overview/older-versions/build-restful-apis-with-aspnet-web-api#setup. I'm having trouble with Task 2 step 8. My ...
0
votes
0answers
21 views
How to compute debit, credit amount in Vendor Bill in Odoo?
I am new to Odoo Accounting. I have been encountering a problem in calculating debit and credit amount of Vendor Bill. I have added two new fields in purchase order line, discount_type and ...
-1
votes
1answer
32 views
PHP Round up long float to two decimals in accounting
Say you have this number 562.9444445 and you want to round it up to 2 decimals. Now I would say that the result would be 562.95 as the 5 is carried up from the tail. No?
Well, the PHP round function ...
0
votes
0answers
14 views
How to change accounting posting periods based on the invoice dates in R?
[Scenario 1: Assuming todays date is 12 Sept 2020, I want the posting date to take the 1 date of Sept for those invoices that are dated Aug and earlier. Our accounting period closes on the 10th of ...
0
votes
0answers
33 views
Accounting cell type changes when read/write - Excel VBA
I am reading some cells of type accounting into a Variant variable and then writing the variable in a new workbook. When I do this, the number formatting gets all mixed up.
I first read the cell from ...
0
votes
0answers
8 views
How to Identify FXSwap trades where Near leg is later than normal spot days (Forward starting FXSwap)
We are looking for a way to identify the FXSwap trades where the near leg is captured after the normal spot days. The trade is captured with the FXSwap product.
We need to identify these trades as the ...
1
vote
2answers
66 views
Sum items together but count separately, groups and subgroups?
I'm looking to sum the $ amounts of pairs of items (top + base) for each month while only counting that pair as 1 unit. Seems easy right?
The only kicker is that a single base can be paired with ...
0
votes
0answers
43 views
Handling Balance in Customer Ledger
I am creating customer ledger in php and mysql. Below is the way in which i am creating this.
First of all an entry added and saved in database. Entry in database is given below.
Entry to the user ...
0
votes
0answers
8 views
MYOB advanced project version
I created a project using MYOB advanced and added some generic enquiries. I am using 2020.3 ā MYOB Advanced Business Release version and the project package that I exported ( in xml) is compatible ...
0
votes
1answer
20 views
Stocks wallet with running values and average buying prices with reset
I was working in a personal investments worksheet and thinking on the smallest amount of information required to make it useful and to be able to compute each asset balance and current average value.
...