How to Setup Online Bank Feeds in Madeira

You need to be sure : The default company, CRONUS, that launches when you first log in to Project “Madeira” does not have electronic bank feeds enabled. To tryout this feature you must switch to trial Company "My Company".

In Project “Madeira” you can connect to most of the online banks and download electronic bank feeds for use in bank reconciliation, avoiding tedious, manual reconciliation, reducing errors, and ensuring that your data is refreshed on a frequent basis.

When you log into MyCompany for the first time, a Company Setup wizard will guide you through setting up the basic company information, including using a bank feed service.

Dont forget to select "Use Bank Feed Service" in Company Setup Page to enable this Service.

You can Manage Bank Accounts & Feeds from Bank Account List Page.



If you enable "Use Bank Feed Service" in Company Setup Page, a new section displays in the ribbon as shown in above screenshot with actions so that you can create a new bank account in Project “Madeira” based on the online bank feed, link already existing bank accounts to online bank feeds, unlinking online bank account feeds, or set up automatic download of feeds on a regular schedule.

When you reconcile bank accounts, you can download bank feeds on demand, as well as process automatically downloaded feeds if you have set up already.

In the Payment Reconcilliation Journal, you can import bank statements based on your bank feeds, and Project “Maderia“ will automatically suggest how payments are applied to ledger entries. You can change the application before you post.

Alternatively, you can import bank statements to the Bank Account Reconcilliation window and reconcile the statements with your ledger entries there.

I will come up with more details in my upcoming posts, till then keep practicing and Learning.

 

 

 

 

Setup Send Documents by Email in Madeira

To enable emails from within Project "Madeira", start the Set Up Email assisted setup on the Home page. We have already seen this in our previous post, you can find it here.

To offer your customers to pay for sales electronically using a payment service, such as PayPal, you can also have the PayPal information and hyperlink inserted in the email body. We have already covered this in our previous post, you can find it here.

From all supported documents, you initiate emailing by choosing the Send action, on posted documents, or the Post and Send action, on non-posted documents.

Let us Setup document-specific email body for sales invoices.

From the search page find Report Selections Sales:



Fill the Value as shown in below screen in same sequence.



If you want to offer customers to pay for sales electronically, you can set up the related payment service, such as PayPal, and then have the PayPal information and hyperlink inserted in the email body as well. We have already covered this in our previous post, you can find it here.

Will come up with more details & feature explaination in my upcomming posts.

 

How Do I : Setup or Adjust Item Cost in Madeira

 

In this post we will see how we can Setup Adjust Cost and how to Run Manually Item Cost Adjust Batch or Schedule the same.



Search the Page Inventory Setup using Search Page in Right top corner of your screen.

Search for Inventory Setup Page.



Make Sure Automatic Cost Posting is Setup as required.

Also Setup frequency of Automatic Cost Adjustment.

Option	Behavior
Never	Costs are not adjusted when posting
Day	Costs are adjusted if posting occurs within one day from the work date
Week	Costs are adjusted if posting occurs within one week from the work date
Month	Costs are adjusted if posting occurs within one month from the work date
Quarter	Costs are adjusted if posting occurs within one quarter from the work date
Year	Costs are adjusted if posting occurs within one year from the work date
Always	Costs are always adjusted when posting, irrespective of the posting date

Now we will Run the Adjust cost Item Entries Batch.


Apply the desired filter for Item or Category as desired.

Next you can run Immediately or can schedule for later execution.

If you require Immediately choose OK.

If you wish to schedule for Later Run choose Schedule.



Enter your Date & Time and click OK.



To check the status of the Scheduled Run, Search and open the Page Job Queue Log Entries.



You can find the Status of your Scheduled Job for Adjust Cost Entries.



It's easy na.

I will come up with more details in my upcoming posts.

Till then keep Exploring & Learning.

 

 

Assisted Setup (Office Add-Ins) in Madeira

In this post we will discuss about how to setup Office Add-Ins.

Select Assisted Setup & Tasks from the ribbon of Action Tab.



Select Setup Office Add-Ins from the list.



Click on Next Button on Welcome Screen.



Select Setup for (Organization or you only) and click on Next Button.



Enter your E-mail id and Password, click on Next to continue with next step.



If you wish to receive few sample mails in your Mail box click on the check box or leave it blank, click on Next Button.



That's it. click on Finish to complete the setup.





That's all for this post.

Will come with more details in my upcoming posts.

Till then keep exploring & learning.

 

Assisted Setup (Email) in Madeira

In this post we will discuss how to setup Email.

Its very easy and single user intervention required.



From Action Tab click on Assisted Setup & Task from the ribbon.



On Welcome screen click on Next Button.



Select the Email Provider and click on Next to continue.



Enter your Email id and password, click on Next Button.



That's it, click on Finish.



 

 



 

Just required to enter Email id and password, setup is done.

Will come with other option in my next post.

Till then keep exploring and learning.

 

 

Assisted Setup (Sales Tax) – in Madeira

Today we will see how Sales Tax setup is done in Madeira. Since preview is limited to US so many of the information may not apply or some different options will be available for other countries. 

Whatsoever may be in final release we will see at that time when finally it will be released. Lets look what is available in this preview.

Login to Madeira using your credentials.

From Action Tab on landing/ Role Center Page on Ribbon click on Assisted Setup & Task.



List with available options page is opened.



Select Setup Sales Tax to continue.

Welcome Screen appears click on Next Button.



Default tax group is created and you can start with other setup, click on Next.



We are only talking about Tax since this preview is only for US so options relevant to them only available. 



Select the Account for Tax Account (Sales & Purchase) using the Assist button which lists you the Available Accounts in COA.



Next City, Country & State related information need to be filled, and then click Next Button to proceed.



Depending upon Information provided in Previous Screen it suggests Tax Area Code, click on Next Button to continue.



We are done with Setup now we will assign this to Customer, Vendor and Company.

Click on Next to continue.



You can Assign the Tax Information to Customer as per entering simple query.

We can assign or we can leave this activity for later.

We have option to schedule a reminder for this activity. Click on Schedule to continue.



Enter the Date and Time for Start & Expiry of this reminder.

This will setup a Job for this and keep reminding you so that you have track of, that this activity is still pending and need to be completed.

Once done choose OK Button to continue.



You can see this in Jobs Entry Page.



Similarly you can do for Vendor too.



For company it will be applicable if you selected, so no separate screen for same for query based assignment.

Select OK to Continue.



We are done with our Tax Setup for Company, Customer & Vendor.

 

That’s all for today, will come up with more information in my next post.

Till then keep exploring and learning.

 

 

Assisted Setup (Data Migration) - Madeira

Login to Madeira using your credentials.

From Home page Action Tab Ribbon choose Assisted Setup & Tasks.



From Assisted Setup Window select Migrate Business Data Task to continue.



From Welcome Screen select Next.



Here you can choose source using which you want to Import Data using Assist Edit Button.



Select Import from Excel option and say OK.



Select Download Template file.



Save the File to desired path.



From Settings Select the Templates you wish to Apply to your Data for Customer, Vendor & Item and choose close to proceed.



Below is the format of Template downloaded in above step. Fill in the data to Import.



When we don't select any template in above step for Customer, Vendor & Item will give confirmation message as below. Choose Yes to proceed.



From next screen Select choose button to specify the Excel file which we prepared in above step using downloaded Template.



This will fetch the data from the file and show you no of records in each table which is going to be imported.



Here if you are familiar with the Rapid Start you can select Advance and perform action accordingly or can skip and proceed to Next Step by selecting Next. Here I am selecting Advance to show the screen.



Confirm with Yes to proceed.



Your Package page will open as shown in above screen, choose Apply Package and handle any import issue with the data to complete the step.



Confirm with Yes to continue.



After processing it will show the status of data, review and fix the issues to continue.



You can drilldown and review the issues and take required steps to proceed with issue fixing and importing of data. Here I choose close to return to previous step of simple import without using Package option.



Select Next to continue with next step.



After processing it will show status of data and errors in data. Say OK to continue.



Here we can choose Show Errors to review the Errors.



We find that in my data most of the issues is related to Gen. Bus. Posting Group, Customer Posting Group, Vendor Posting Group, etc... We can fix these issues later, so just respond Close to continue with Next step.



Our data is now Imported with errors, we will take care of issues with data as reviewed above. Respond Finish to complete this step & Process.



Now you can see this step is marked as completed in Status.

Our data is imported we will access the data and fix the issues accordingly.

I will come up with more details in my upcoming posts.

Till then keep exploring and Learning.