Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Accounting is a function of an organization that produces financial records. These questions are related to utilizing software to complete accounting tasks

1
vote
1answer
34 views

Multiple sales taxes in a sales receipt

I am using Quickbook online. I am trying to add multiple sales tax (Both state and county tax) in a sales receipt. But QBO only allows me to add only one tax. How can I add multiple tax rates in one ...
1
vote
2answers
120 views

Excel Forecast model for subscriptions received in advance for next 2 years

I am working on a financial model that contains: Months in columns (Jan-2020 to Dec-2025) Number of subscribers per month (column) per package in rows Price of each package in rows Doing cash flow ...
1
vote
0answers
37 views

User Login/logout accounting to enforce max session time?

I'd like to set up a home system where users (i.e., house kids) have a given max time of computer use per day/week/whatever, and after that time they're logged off. They should be able to log in and ...
1
vote
1answer
60 views

Add Accounting Radius in the RAS (VPN) Configuration

I'm trying to create a powershell script for configuring a specific VPN remote access server in a Windows Server 2012-R2, the following command works fine but how can i configure accounting radius too?...
1
vote
1answer
1k views

How to make a graph of bank account data in excel with a table of balance changes?

I have an excel table with dates and according bank account balances. Now I add a graph and get the following: The graph should have a timeline on the x-axis - that works. But I want the data to be ...
0
votes
2answers
2k views

How do I use Excel to categorize bank transactions into easily understandable categories to see where my money is going?

My boss wants our bank transactions categorized manually. Right now my task is to go through the bank transactions and categorize them into categories based on what each item is. For random ...
0
votes
2answers
3k views

How to calculate revenue equally based on start and end dates?

My company phases revenue based on slightly obscure start/end dates and I need calculate how much revenue falls into the current year, based on these dates. If a contract starts on or after the 16th ...
0
votes
1answer
71 views

Unix accounting: lastcomm commands with no on-disk executables - what are they?

A security related exercise: For extra security, I have traditional Unix accounting (acct) turned on. This can help investigate suspicious activity after the fact. According to the man page /var/log/...
1
vote
1answer
3k views

How to change default Accounting Number Format?

In most cases, the default accounting format in Excel is $ Without using some kind of macro Without changing timezone (or other system settings) of the computer How to change this and set ...
1
vote
1answer
2k views

Data reconciliation with pivot table

I have 2 tables (table1, table2), each with 2 categorical variables/columns (product, country) and up to 5 real-valued variables to be reconciled/compared against each other (sales and other in the ...
0
votes
1answer
57 views

QuickBooks (Mac) Chart of Accounts has an empty column with a blue ball heading

QuickBooks 2014 (Mac) I'm simply looking for an explanation of an empty column in my Chart of Accounts. Its header is nothing but a blue ball. Hovering and clicking this column heading reveals ...
0
votes
0answers
164 views

Data field not showing on invoice (QuickBooks 2013 R12)

My QuickBooks just updated to R12, and it seems that one of the data fields as inserted in the layout editor is not showing in on the final invoice, or the preview. It just leaves an empty space. The ...
0
votes
1answer
126 views

Gnucash: how to breakdown assets by various accounts?

Suppose I have the following accounts in Gnucash: Assets Bank A Risky account, $1000 Non-risky account, $2000 Bank B Risky account, $5000 Non-risky account, $...
14
votes
3answers
2k views

How to move Mint transaction data to GnuCash

Online financial aggregators are great for getting transactions from all of your accounts into one place, but the accounting tools they provide are pretty minimal. I'm a Mint user, and I like the idea ...
5
votes
2answers
22k views

How do you reverse the sign of a range of numbers in Excel?

In accounting I sometimes download statements where although the transaction represents debit, the sign is negative. I then need to change the sign to be positive so it's actually indicating a true ...

15 30 50 per page