
Pay Day
Introducing Salary Identification and Split Payments. Pay day just got a whole lot better with Up.
4 min read
Join 300,000+ Upsiders by downloading Up today.
On a desktop?
SMS yourself a link
or scan this QR code using your phone.
Oct 31, 2019 · 3 min read
A commonly requested feature from Upsiders is getting their data out of Up, so that they can use it in budgeting software, or in Excel, or some other means to view their data on not-a-phone.
So, we've added the ability to export to a CSV, which you can then share from your phone to your computer (or, if you're brave, work with it directly on your phone 😬).
CSV is short for 'Comma-separated values' (not Custom Savings Viewer - but that's what you can build with it), and lets us output your data in a format that can be read by many other programs.
You can grab it by going to any monthly overview, hitting the three dots in the top right, and tapping 'Download CSV'.
If you just want to jump in and see what you can do with this data, we've created a small Google Sheet which you can use as a starting point.
Hopefully these give you a bit of inspiration. From here, you can add whatever you like. If you make something cool, be sure to show us on Twitter (you'll almost certainly get a retweet from Dom) or through Talk to Us.
If you want to try your hand at building your own integration, either in Excel or your favourite programming language, continue on below, where I've detailed each of the columns that you'll find in the export.
Let's go over what's included:
Time: this is the date + time that your transaction happened at
BSB/Account Number: The details of the account this transaction was made from
Transaction Type: the method of money movement - we're always updating, so don't rely on this list never changing.
Purchase
: this one is pretty self-explanatory - you've made a purchasePayment
: You've sent money to someoneDeposit
: Someone has sent you moneyDirect Debit
: ...it's a direct debitDirect Credit
: Another way to have money deposited into your accountBPAY Payment
: You've made a payment via BPAYATM Cash Out
: Withdrawing from an ATMATM Operator Fee
: Money paid to use an independent ATMOverdrawn Interest
: Interest charged if you ever go overdrawn.Round Up
: An 'orphaned' round-up. This happens only very occasionally when
a company places a 'Hold' on your card, and then later withdraws the hold.Salary
: A payment into your account from your employerScheduled Transfer
: Keep an eye out for a future blog about this one 😉.Transfer
: A transfer between your accountsPayee: The person or account who you have sent money to or received money from.
Description: Essentially a free-text field. Shows the raw merchant details if it's a purchase, the message you've sent if it's a transfer, etc.
Category: The category of the transaction inside of Up.
Tags: A comma-separated list of tags applied to a transaction. Yup. There is a CSV inside the CSV.
Subtotal: The amount charged, in AUD (regardless of purchase currency), before any fees or round-ups are applied.
Currency: The ISO 4217 currency code for the currency the transaction was made in. E.g. AUD, USD.
Subtotal (Transaction Currency): The amount charged, in the transaction currency. You can combine this with Subtotal to calculate the exchange rate.
Fee (AUD): The fee, if applicable, on the transaction. Hint: it's very often $0.
Round Up (AUD): The amount moved to your round up saver due to the given transaction
Total (AUD): Subtotal + Fee (AUD) + Round Up (AUD). This is the total effect the transaction had on your account balance
Payment Method: The method used to move money around. This is generally only for payments you've sent/other people have sent you. You might see:
Settled Date: This is when the transaction actually settled.
If you feel like we've missed something that you really need, feel free to jump on 'Talk to Us' in-app and let us know 💡.
We'll swing our monthly newsletter and release notes your way.
Introducing Salary Identification and Split Payments. Pay day just got a whole lot better with Up.
4 min read