How To Upload Files and Export Your Transactions
Novat
|
32 steps
|
2 minutes
Novat
127.0.0.1
1
Navigate to [https://novat.ai](http://127.0.0.1:8000/launch/Client/)
2
To navigate to your "Launch" page, first make sure that you are on "My Dashboard"
3
Click "Launch" for the client you want to upload files for
Tip! Set up the AI Faster by clicking[Get in Touch](https://www.novat.ai/contact/) in the message, include: 1. A little bit of information about your client and which industry they operate in 2. The list of your Chart of Accounts 3. We'll get back to you in 1-2 business days and let you know when the AI is ready!
Background: How to Navigate the Launch Section
4
You can navigate different launch sections by clicking the tabs
5
Or by clicking "Next" or "Back"
Now Let's Start
6
Start in "Drop Files". Click "Upload Files"
Tip! You can upload ONE or MULTIPLE PDF files. To see which files we accept, click [Novat-Different Bank Types ](https://docs.google.com/document/d/1bFEouxLS6_SgZSc0z3Wia8a1BsfghHzpOVA66r67DgI/edit?usp=sharing)
Tip! To request an additional bank or or file type, send us a message by clicking [Get in Touch](https://www.novat.ai/contact/)
7
The files you upload will show up here
8
"View" shows all transactions extracted from your PDF statement
9
Click "Summary" to view a summary of your data transactions
10
Click "x" once you're done
11
Click "Next" to navigate to "Credit/Charges"
Tip! "Credit/Charges" Do not show all the transactions with the same vendor-- the duplicates are removed. To see all transactions from the same vendor, either click on "View" or "Download". We know this is not optimal. We are working on fixing it in our next version.
12
"Credit/Charges" shows a summary of bank credits. Click on any item to make necessary edits
13
Click on any item in "Vendor/Payee" to make necessary edits
14
The "Memo" column can be referenced to check the Vendor/Payee.
15
The "Vendor/Payee Description" column can be referenced to find more information on what industry the Vendor/Payee operates in.
16
Click "Save All" to save your changes
Tip! To make multiple changes at once, try copying a value, then clicking on "shift" then "down arrow"
17
Click a cell
18
Press [[cmd]] + [[c]]
19
Press [[shift]] , Click [[down]] [[down]] [[down]]
20
Press [[cmd]] + [[v]]
21
Click "Next" to go to "Debits/Payments".
22
Same as before, you can edit the "Account" or "Vendor/Payee" columns.
23
Don't forget to "Save All"
24
Click "Next" to go to the "Download" page
25
Here you can view all your finalized Vendor/Payees and Account categorizations.
Tip! You cannot edit the download page. If you need to make changes, go back to the "Credit/Charges" page or the "Debits/Payments" page
26
Click "Export" to export transactions
27
Click the checkbox of columns you want to include.
Tip! The order of the columns can be changed by dragging and dropping
28
Drags the different items up and down to change the order of the columns
29
For example, "Date" has been dragged from position Number 1 to position Number 4
30
Choose whether you want you "Amounts" column to be "One Combined Column (+) (-)" or "Two Separate Columns"
31
Click "Download Excel"
32
Click "x" to cancel and go back
Tip! To learn more about exporting transactions to QuickBooks Desktop read our next guide. Click [Export Novat Transactions Into QuickBooks Desktop](https://scribehow.com/shared/Export_Novat_Transactions_Into_QuickBooks_Desktop__6Qd5LmFBRdeLPTBXxaiuvw?referrer=workspace)